Retrieving Data by Using LINQ to Entities

A simple snippet that let’s you know how to retrieve data by using LINQ to Entities. Just follow it through, I guess it’s self-explanatory.

C# .NET Entity Framework

            // Retrieving Data by using LINQ to Entities
            using (EMSEntities context = new EMSEntities())
            {
                ObjectQuery<Order> orders = context.Orders;
                IQueryable<Order> query = from c in orders where
                                              c.OrderID == 1 select c;
                List<Order> results = query.ToList();
                string orderID = results[0].OrderID.ToString();
                string orderDate = results[0].OrderDate.ToString();
                Debug.WriteLine(String.Format("Order ID = {0}, " +
                    " Order Date = {1}", orderID, orderDate));
                EntityCollection<OrderDetail> details =
                    results[0].OrderDetails;
                Debug.WriteLine(String.Format(
                    "Order Detail Count = {0}", details.Count));
            }

Incoming search terms:

• retriving data using date in linq
• advantages of using linq to entities in net
• filtering data using linq to entities in c#
• retrive data from hashtable using linq