The article provides a quick guide to understanding Entity Framework. Why Entity Framework? Entity Framework is an ORM layer which implements the Unit of Work pattern. For ASP.NET, the request processing can be considered as a business transaction. Entity framework keeps
ASP.NET Identity Framework 2.0 is integrated with EntityFramework and provides entity classes to deal with Users, Roles, Claims, and third-party Logins. The Identity database can be any store – SQL Server, MySQL or Oracle. This article will provide guidance on
The Entity Framework tutorials site has a nice article on configuringmany-to-many relations. In this post, the same case study is implemented on a MySQL database. In addition, the association table has additional useful fields. Example There are two tables: Students
SQLite is an open-source SQL database engine. It is widely used in iOS apps. Create SQLite Database SQLite has an executable sqlite3.exe. To create a database with name accounting: Open the command prompt. Execute “sqlite3 accounting.sqlite”. The above command creates
I want to refresh a table with data from a flat file. Technically, this boils down to: delete all rows from the table, and insert new rows. I have already got a lot of code based on Entity framework. So,
I searched the web for a comparision between Entity Framework vs LINQ to SQL. The most popular thread comes from StackOverflow. After going through several such links, I have compiled a few major differences which I am outlining in this post.