static void PrintOrderForCustomer(AutoLot carsDB) { int custID = 0; Console.Write("Enter customer ID: "); custID = int.Parse(Console.ReadLine()); var customerOrders = from cust in carsDB.Customers from o in cust.Orders where cust.CustID == custID select new { cust, o }; Console.WriteLine("***** Order Info for Customer ID: {0}. *****", custID); foreach (var q in customerOrders) { Console.WriteLine("{0} {1} is order ID # {2}.", q.cust.FirstName.Trim(), q.cust.LastName.Trim(), q.o.OrderID); Console.WriteLine("{0} bought Car ID # {1}.", q.cust.FirstName.Trim(), q.o.CarID); } Console.WriteLine("\ncustomerOrders as a string: {0}", customerOrders); }
static void Main(string[] args) { Console.WriteLine("***** More Fun with LINQ to SQL *****\n"); AutoLot carsDB = new AutoLot(cnStr); InvokeStoredProc(carsDB); Console.WriteLine(); PrintOrderForCustomer(carsDB); Console.ReadLine(); }
private static void InvokeStoredProc(AutoLot carsDB) { int carID = 0; string petName = ""; Console.Write("Enter ID: "); carID = int.Parse(Console.ReadLine()); // Invoke stored proc and print out the petname. carsDB.GetPetName(carID, ref petName); Console.WriteLine("Car ID {0} has the petname: {1}", carID, petName); }
public LinqGen() { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder { DataSource = @"(local)\SQLEXPRESS", InitialCatalog = "AutoLot", IntegratedSecurity = true }; autoLot = new AutoLot( builder.ConnectionString ); dataContext = new AutoLotObjectsDataContext( builder.ConnectionString ); //InvokeStoredProcedure(); //PrintOrder(); //InsertNewCar(); //UpdateCar(); DeleteCar(); }