in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Creating a model

Last post 01-11-2010 7:07 AM by pdandrey. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 12-01-2009 7:48 AM

    • svenM
    • Not Ranked
    • Joined on 12-01-2009
    • Posts 3

    Creating a model

    Hello, 

     I have a problem when using entity framework with linq : 

    I tried following these steps : http://kubasik.net/blog/2009/02/09/using-linq-to-sqlite-providers-updated/

    And I can create a connection in server explorer, 

    but when I add an entity data model and choose from database I cannot select that connection, 

    also when trying to create a new connection in this window I cannot select the sqlite dataprovider.

     

    When I installed the provider I selected install designtime support. 

     

    Can anyone help? 

     

    Thanks in advance!

    Sven

  • 12-09-2009 9:53 AM In reply to

    Re: Creating a model

     i had this same problem!

  • 12-10-2009 3:55 AM In reply to

    • svenM
    • Not Ranked
    • Joined on 12-01-2009
    • Posts 3

    Re: Creating a model

     If you had this problem, were you able to solve it?

     Thanks.

  • 01-09-2010 4:47 PM In reply to

    • magik
    • Top 500 Contributor
    • Joined on 01-09-2010
    • Posts 4

    Re: Creating a model

     (My Visual Studio 2008 is in french so there could be some inconsistencies, sorry.)

    - Start your project

    - Select the project in solution explorer

    - Add a new element

    - select "ADO.NET Entity Data Model" and name it

    - Generate from Database

    - New connection -> Modify the datasource -> "SQLite Database file" should be there with ".Net Framework Data Provider for SQLite" as the provider

    Select the database and whatever you want and it should work without any problems.

     

    Hope this helps. (I'm probably a bit late though as I just joined today.)

  • 01-11-2010 3:43 AM In reply to

    • svenM
    • Not Ranked
    • Joined on 12-01-2009
    • Posts 3

    Re: Creating a model

     Thank you for your reply,

    I tried that, but when i try to add a new connection there is no sqlite database or sqlite provider there. 

    I have tried reïnstalling the provider but no result.

     

  • 01-11-2010 7:07 AM In reply to

    Re: Creating a model

    I had the same problem with 1.0.65.  I downgraded to 1.0.64 (uninstalled 1.0.65 then installed 1.0.64) and everything is working great.
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems