Eneity framework执行SQL

 

using (var edm = new NorthwindEntities ())

{

    string sqlStr = "SELECT VALUE o FROM NorthwindEntities.Orders AS o WHERE o.Customers.Country = 'Mexico'" ;

 

    ObjectQuery <Orders > query = edm.CreateQuery<Orders >(sqlStr);

    ObjectResult <Orders > result = query.Execute(MergeOption .NoTracking);

 

 

    foreach (Orders o in result)

    {

        Console .WriteLine("{0},{1}" , o.OrderID, o.Customers.Address);

    }

 

    Console .WriteLine(query.ToTraceString());

}