Demo of ADO.NET POCO with SQLite database

This demonstration shows how to prepare for and how to implement model-first ADO.NET POCO objects with a SQLite backing store.

C# (46.5 KB)
 
 
 
 
 
5 Star
(1)
3,305 times
Add to favorites
9/12/2011
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Visual Studio 2010 Professional exe.config File To Add dependentAssembly Change
    3 Posts | Last post February 28, 2013
    • Marin;
      
      First and foremost, thank you for your example on ADO.NET POCO With SQLite Database on the MSDN Code Gallery.  I really and truly appreciate your efforts. 
      
      I did have a follow-up configuration question on the proper location and the name of the config file to modify in step #5 of the demo, in which we need to add the assembly binding for the data designer to work correctly with the SQLite Mixed Mode DLL.  In your instructions, you mention that the VCSExpress.exe.config file needs to have the <dependentAssembly> added.  I'm running Visual Studio 2010 Professional, and I do not have a VCSExpress.exe.config file in my local C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE directory, but I do have a devenv.exe.config file, which seems to have a number of definitions for other <dependentAssemly> elements.  Is this the file I need to add the SQLite Mixed Mode DLL configuration setting?
      
      Thank you in advance for your time and help. I really appreciate it.
      
      Best Regards...
      
    • Yes, I think you are correct. I have developed this example using Visual Studio Express, hence the name of VCSExpress.exe.config. I suppose that when you have VS 2010 Professional, the executable is called devenv.exe and the configuration file is called devenv.exe.config. 
      
    • Thanks!
      
      It worked for me on Visual Studio 10 and EntityFramework 4.
      
      - In step 4 copied the file to: C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen
      
      - I omitted step 5, because the entry was already in the devenv.exe.config file.
      
      I've first backed up the original SSDL from EDMX file, because when generating the database, it overwrites it.