WAFY's .NET Specialists Blog

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