All geek questions in one place

The easiest way to set up a file database using Entity Framework

I am developing an application, partly to learn new technologies - in this case, the Entity Framework. I am using .NET 4.5, Visual Studio 2013. I need to somehow store data that does not include starting the SQL server on my legacy old laptop (even hard), and it works with Entity Framework. Ideally, I would like something that just stores data in a file. I have a few basic requirements:

  • Simple relational database. Maximum 10 tables, this is a prototype, so the tables will not be very large
  • Ability to create a database in some kind of graphical interface.
  • Ability to create an Entity Framework database model from a database. I do not want to enter them manually.
  • There is no proprietary software besides what I already use - i.e. I do not have an MS Access license.
  • Something THAT COMBINE

I spent most of today trying to get VS2013 to connect me to the SQLite database that I created. I have never gone anywhere. SQLite is simply not on the list of available data source types. I read StackOverflow posts about this issue and I tried to get it working. (this is where the frustration you might feel in this post comes from this - this is not an exercise item, but I spent so much time on it) Is there any other file-based database technology that I could use?

+4
source share
2

, - SQLite, EF CodeFirst.

SQLite ​​ : http://www.bricelam.net/2012/10/entity-framework-on-sqlite.html

+1

SQL Server Compact SQL Server Compact Toolbox VS:

. 10 , ,

  • SQL CE 4 .

-

  • Visual Studio

Entity Framework . .

  • ,

, , - MS Access

  • SQL Compact
+1

Source: https://habr.com/ru/post/1622259/

More articles:


All Articles