//ExStart:GetSingleCustomerDT /// <summary> /// Fetches Customers from database /// </summary> /// <returns>Returns DataSet, very first record from the table</returns> public static DataRow GetSingleCustomerDT() { DatabaseEntitiesDataContext dbEntities = new DatabaseEntitiesDataContext(); var customers = (from c in dbEntities.Customers select new { c.CustomerID, c.CustomerName, c.ShippingAddress, c.CustomerContactNumber, c.Photo }).AsEnumerable(); DataTable Customers = new DataTable(); //ToADOTable function converts query results into DataTable Customers = customers.ToADOTable(rec => new object[] { customers }); Customers.TableName = "Customers"; DataSet dataSet = new DataSet(); //Adding DataTable in DataSet dataSet.Tables.Add(Customers); return dataSet.Tables["Customers"].Rows[0]; }
//ExStart:GetSingleCustomerDataDB /// <summary> /// Fetches single customer data /// </summary> /// <returns>Return single, first customer's data</returns> public static Customer GetSingleCustomerDataDB() { //create object of data context DatabaseEntitiesDataContext dbEntites = new DatabaseEntitiesDataContext(); IEnumerator<Customer> customer = GetCustomersDataDB().GetEnumerator(); customer.MoveNext(); return customer.Current; }
//ExStart:GetProductsDataDT /// <summary> /// Fetches Products and ProductOrders information, store them in DataTables and load DataTable to DataSet /// </summary> /// <returns>Returns DataSet</returns> public static DataSet GetProductsDT() { DatabaseEntitiesDataContext dbEntities = new DatabaseEntitiesDataContext(); var products = (from c in dbEntities.Products select c).AsEnumerable(); var productOrders = (from c in dbEntities.ProductOrders select c).AsEnumerable(); DataTable Products = new DataTable(); //ToADOTable function converts query results into DataTable Products = products.ToADOTable(rec => new object[] { products }); DataTable ProductOrders = new DataTable(); ProductOrders = productOrders.ToADOTable(rec => new object[] { productOrders }); ProductOrders.TableName = "ProductOrder"; Products.TableName = "products"; DataSet dataSet = new DataSet(); //Adding DataTable in DataSet dataSet.Tables.Add(Products); dataSet.Tables.Add(ProductOrders); return dataSet; }
//ExStart:GetProductsDataDB /// <summary> /// Fetches products from database /// </summary> /// <returns>Returns products information, one data at a time </returns> public static IEnumerable<Product> GetProductsDataDB() { //create object of data context DatabaseEntitiesDataContext dbEntities = new DatabaseEntitiesDataContext(); return dbEntities.Products; }
//ExStart:GetOrdersDataDB /// <summary> /// Fetches orders from database /// </summary> /// <returns>Returns order details, one data at a time</returns> public static IEnumerable<Order> GetOrdersDataDB() { //create object of data context DatabaseEntitiesDataContext dbEntities = new DatabaseEntitiesDataContext(); return dbEntities.Orders; }
//ExStart:GetCustomersAndOrdersDataDT /// <summary> /// Fetches Orders, ProductOrders and Customers from database /// </summary> /// <returns>Returns DataSet</returns> public static DataSet GetCustomersAndOrdersDataDT() { DatabaseEntitiesDataContext dbEntities = new DatabaseEntitiesDataContext(); var orders = (from c in dbEntities.Orders select c).AsEnumerable(); var productOrders = (from c in dbEntities.ProductOrders select c).AsEnumerable(); var customers = (from c in dbEntities.Customers select c).AsEnumerable(); DataTable Orders = new DataTable(); //ToADOTable function converts query results into DataTable Orders = orders.ToADOTable(rec => new object[] { orders }); DataTable ProductOrders = new DataTable(); ProductOrders = productOrders.ToADOTable(rec => new object[] { productOrders }); DataTable Customers = new DataTable(); Customers = customers.ToADOTable(rec => new object[] { customers }); ProductOrders.TableName = "ProductOrder"; Orders.TableName = "Orders"; Customers.TableName = "Customers"; DataSet dataSet = new DataSet(); //Adding DataTable in DataSet dataSet.Tables.Add(Orders); dataSet.Tables.Add(ProductOrders); dataSet.Tables.Add(Customers); return dataSet; }