.NET FAQ - Execute SQL Text Command with Entity Framework

The following example shows how to execute a SQL text queries and commands directly against the database using Entity Framework 4. We will make use of the ExecuteStoreQuery and ExecuteStoreCommand methods.

Query Example

using (var ctx = new YourEntities())
{
    ctx.ExecuteStoreQuery<string>("SELECT [ColumnName] FROM [YourTableName]");
}

Command Example

using (var ctx = new YourEntities())
{
    ctx.ExecuteStoreCommand("DELETE FROM [YourTableName]");
}