LINQ to SQL you can use CompiledQuery to improve performance.
public static Func<Northwnd, string, IQueryable<Customer>>
CustomersByCity =
CompiledQuery.Compile((Northwnd db, string city) =>
from c in db.Customers where c.City == city select c);
public static Func<Northwnd, string, IQueryable<Customer>>
CustomersById = CompiledQuery.Compile((Northwnd db,
string id) => db.Customers.Where(c => c.CustomerID == id));
public IEnumerable<Customer> GetCustomersByCity(string city)
{
var myDb = GetNorthwind();
return Queries.CustomersByCity(myDb, city);
}
Author:
Aamir Hasan औथोर:
आमिर हसन أثر
أمير حسن .
b8223c36-5178-4137-8138-f489e1735ddc|0|.0
ALL, asp.net, SQL 2005 & 2008
asp.net, sql, linq