This post shows a T-SQL script that can be used to generate the properties for a class that correspond to to a field in a database table. This can be used with Entity Framework.
The following shows how to setup a proper connection string and DbContext in Entity Framework in order to connect to a SQL Compact database in ASP.NET.
Example on how to use the LIKE functionality in T-SQL in Entity Framework
A common problem with parameterized queries is when you have the need for a WHERE IN clause and the IN list is variable. This is solved with Entity Framework using the Contains methods of the list.
The follow example shows how to get a list of objects that are distinct based on a property's value.
The following example shows how to query a table and count records associated in another
C# Examples on how to use inheritance in Entity Framework
C# DbSet extension functions for Add and Update
How to specific the table name on an entity class in Entity Framework