rahimi.mohamad24
چهارشنبه 02 بهمن 1392, 14:47 عصر
من میخوام بتونم با Entity Framework، یه کوئری بنویسم و اجراش کنم. سرچ کردم به نمونه ی زیر برخوردم:
using (var context = new SalesOrderManagementEntities())
{
//Query all the customers using Entity SQL
string querystring = "SELECT VALUE Customer FROM SalesOrderManagementEntities.Customer AS Customer";
ObjectQuery Customers = context.CreateQuery(querystring);
foreach (Customer result in Customers)
Console.WriteLine(String.Format("{0} {1}",
result.Name, result.Address));
}
using (var context = new SalesOrderManagementEntities())
{
//Query all the customers using Entity SQL
string querystring = "SELECT VALUE Customer FROM SalesOrderManagementEntities.Customer AS Customer";
ObjectQuery Customers = context.CreateQuery(querystring);
foreach (Customer result in Customers)
Console.WriteLine(String.Format("{0} {1}",
result.Name, result.Address));
}