WAFY's .NET Specialists Blog

We have plans on bringing Visual Studio 11 and .NET Framework 4.5 as part of our training program. For those eagerly waiting to know about the next big release of Visual Studio 11, take a peek here:

http://msdn.microsoft.com/en-us/vstudio/hh127353
http://www.asp.net/vnext/whats-new

A simple snippet that let’s you know how to retrieve data by using Entity Client Provider. You can refer to the DataModel image in the earlier post.

            // Retrieving Data by Using the EntityClient Provider
            // Entity Connection, Command and Parameter objects
            using (EntityConnection connection =
                new EntityConnection("name=EMSEntities"))
            {
                connection.Open();
                // Note that "Order" is the actual table name
                const string queryString = @"SELECT VALUE r FROM
                    EMSEntities.Orders as r WHERE r.OrderID=@OrderID";
                EntityCommand cmd = new EntityCommand(queryString,
                    connection);
                EntityParameter p = new EntityParameter() {
                    ParameterName = "OrderID", Value = 1 };
                cmd.Parameters.Add(p);
                EntityDataReader reader =
                    cmd.ExecuteReader(CommandBehavior.SequentialAccess);
                while (reader.Read())
                {
                    string orderID = reader.GetInt32(0).ToString();
                    string orderDate  = reader.GetDateTime(1).ToString();
                    Debug.WriteLine(String.Format("Order ID = {0}, " +
                        " Order Date = {1}", orderID, orderDate));
                }
            }

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));
            }