I’ve just solved a problem about creating database. The application was working well until now we delete the old database to let Entity Framework creating a new one.

EntityFramework contains ObjectQuery type which supports to perform advanced and dynamic query for entity with SQL-like syntax.

This post will drive you to create WCF Data Service and how to use it in your client application. A Windows Console application will be created to comsume the service by using its proxy. For Web application, it can be called by activating URL with HTTP method.

There are different data access technologies including ADO.NET, Entity Framework, WCF Data Services… with different benifits. Below is some key points of those technologies

Basis of mapping in Entity Framework, how to map a POCO to table and customize mapping using Fluent API.

Reading a series of posts Data Points - Coding for Domain-Driven Design: Tips for Data-Focused Devs have a look back to what I have done with.

Continuing on my previous post regarding EF-Azure for project IOnline, I need to adapt this requirement to: (1) Not using EF to count number of messages (total messages in the system and by categories) and (2) Use Dapper for the data access layer as a replacement. So I will have to create some stored procedures to make this works.

When working with EF Code First approach, we must update system database after modified model entities and of course, we must create a migration (or many migrations, depending on how are your changes). Later we can update the database manually or automatically (on the first read/write to the database).