I'm Evaluating the Devart SQLite ADO.NET for my company. We're using MVC4 with Visual Studios 2012. Using Database first and Code first I have had some success at building databases and generating models. However it has been slow with lots of errors, after more than a week I still don't have a stable solution! I cannot find an Example anywhere using Devart SQLite with MVC4, is there one?
The connectionString parameters seem to be the key ? Here is mine:
<add name="SchoolContext" connectionString="Data source=c:\TesDB\test.db;FailIfMissing=false;" providerName="Devart.Data.SQLite" />
Here’s my latest problem:
1) I create a model and context.
2) I create a single controller from the model
3) Run the program and it creates the database which I can input data into from the single controller.
4) I try to create another controller using same model and context I get this error :
Unable to retrieve metadata for MyClass Using the same DbCompiledModel to create contexts against different types of database servers is not supported. Instead, create a separate DbCompiledModel for each type of server being used.
I am not new to DOT.NET or MVC... any help would be appreciated.
Code First not working with MVC4
Re: Code First not working with MVC4
We cannot reproduce the issue using dotConnect for SQLite v 4.4.179. Please send us a small test project and specify the steps we should follow to reproduce the problem in our environment.