masterfy

 

(转)Using LINQPad with Entity Framework

LINQPad lets you query Entity Framework models that you define in Visual Studio. In a nutshell, here's how to proceed:

  1. Create an ADO.NET Entity Data Model in a Visual Studio project, and build.
  2. From LINQPad, click Add Connection (top left)
  3. Set the Data Context dropdown to Custom Entity Framework ObjectContext:
    Entity Framework DataContext Dropdown
  4. Click Browse and locate the assembly (DLL or EXE) that you built in step 1:
    Entity Framework Choose Assembly
  5. Choose your typed ObjectContext class and Entity Data Model: Entity Framework Choose EDM
  6. Confirm the SQL Server and database details and click OK.
  7. Your Conceptual Model will now show in the Schema Explorer. Right-click to start a new query:
    Entity Framework Schema TreeView

A few notes:

  • You can return to Visual Studio at any time and rebuild - LINQPad will not lock your assembly.
  • LINQPad automatically refreshes the schema explorer and autocompletion cache whenever the assembly changes.
  • If your assembly references other assemblies, LINQPad will pick up these, too, providing they live in the same folder.

http://www.linqpad.net/EntityFramework.aspx

 

posted on 2010-01-06 16:23  masterfy  阅读(341)  评论(0编辑  收藏  举报

导航