Search Wiki:
Resource Page Description
Entity SQL tools and samples. eSqlBlast home.
Last edited Jan 24 2008 at 8:33 AM  by zmichailov_MSFT, version 2
Comments
RogerJ wrote  Oct 21 2008 at 7:06 PM  
eSqlBlast requires access to physical SSDL, MSL and CSDL files in a folder that you designate as metadata.
See Julie Lerman's eSqlBlast Tip post (http://www.thedatafarm.com/blog/2008/05/27/eSqlBlastTip.aspx) for details about creating the required files.

--rj
http://oakleafblog.blogspot.com

staceyw wrote  Nov 18 2008 at 5:39 AM  
Hi Roger. Still don't understand how to create the SSD, MSL and CSDL from a model file I generated using the designer? Can't start eSqlBlast. Please provide a step by step readme. tia

nc1943 wrote  Jun 25 2009 at 6:27 AM  
Just to be verbose, what is meant in Julie's post is:
1. In the VS 2008 Model Browser pane of the EF designer window, click on the Model node/icon of the tree view (the node that is the parent of EntityTypes, Associations, etc.)
2. Hit <F4> to bring up the properties pane for the model. There you will see a property called "Metadata Artifact Processing".
3. Change this property to "Copy to Output Directory" (put it back "Embed in Output Assembly" when deploying and such)
4. Rebuild the project containing your EF model
5. Check your bin directory and you should see the .csdl, .msl, and .ssdl files that eSqlBlast needs
6. Start the eSqlBlast WinShell app
7. On the eSqlBlast Connection tab set your db connection properties in the "Provider Connection String" box.
8. For the Metadata box click the "Add Files" button, browse to the bin of your project and select the .csdl, .msl, and .ssdl files you just generated.
9. Click the Connect button
10. Switch to the Query tab and runs some Entity SQL queries against your model.

Updating...
Page view tracker