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.
The following methods will allow you to map your DataTable, DataRow results to a class object.
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
Quick Reference guide for C# Razor syntax
C# Examples on how to use inheritance in Entity Framework