As you saw in the sample project LinqToEntitiesDemo, with the ADO.NET Entity Framework, you can use T-SQL commands directly, sending them to SQL Server for execution. For example, the method LinqToEntitiesDemo disables the trigger on the Vendor table by using the following T-SQL statement:
awContext.ExecuteStoreCommand("disable trigger Purchasing.dVendor on Purchasing.Vendor")
When using T-SQL commands directly, you lose one of the great advantages of the Entity Framework—separation of the conceptual data model from the database. Using T-SQL statements directly can compromise your application’s compatibility with other databases.
Entity Framework 4.0 adds some new methods to the object ...