LINQ & Entity
DataSet 을 Linq로 쿼리하기
스티커
2010. 10. 6. 15:03
DataSet ds = new DataSet(); FillOrders(ds); // this method fills the DataSet from a database DataTable orders = ds.Tables["SalesOrderHeader"]; var query = from o in orders.ToQueryable() where o.Field<bool>("OnlineOrderFlag") == true select new { SalesOrderID = o.Field<int>("SalesOrderID"), OrderDate = o.Field<DateTime>("OrderDate") }; foreach(var order in query) { Console.WriteLine("{0}\t{1:d}", order.SalesOrderID, order.OrderDate); }