static void Main(string[] args)
{
//Make new instance of the Cars Collection
//Probably going to be CarsFInitalLName for you.
CarsTestEntities carsTestEntities = new CarsTestEntities();
//*************************************
//List out all of the cars in the table
//*************************************
Console.WriteLine("Print the list");
foreach (Car car in carsTestEntities.Cars)
{
Console.WriteLine(car.id + " " + car.make + " " + car.model);
}
//************************************************
//Find a specific one by any property
//************************************************
//Call the Where method on the table Cars and pass in a lambda expression
//for the criteria we are looking for. There is nothing special about the word
//car in the part that reads: car => car.id == "V0...". It could be any characters we
//want it to be. It is just a variable name for the current car we are considering
//in the expression. This will automagically loop through all the Cars, and run the
//expression against each of them. When the result if finally true, it will return
//that car.
Car carToFind = carsTestEntities.Cars.Where(
car => car.id == "V0LCD1814").First();
//We can look for a specific model from the database. With a where clause based on any
//criteria we want we can narrow it down. Here we are doing it with the Car's model
//instead of it's id.
Car otherCarToFind = carsTestEntities.Cars.Where(
car => car.model == "Challenger").First();
//Print them out.
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Find 2 specfic cars");
Console.WriteLine(carToFind.id + " " + carToFind.make + " " + carToFind.model);
Console.WriteLine(otherCarToFind.id + " " + otherCarToFind.make + " " + otherCarToFind.model);
//*******************************************
//Find a car based on the primary key
//*******************************************
//Pull out a car from the table based on the id which is the primary key
//If the record doesn't exist in the database, it will return null, so check
//what you get back and see if it is null. If so, it doesn't exist.
Car foundCar = carsTestEntities.Cars.Find("V0LCD1814");
//Print it out
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Print out a found car using the Find Method");
Console.WriteLine(foundCar.id + " " + foundCar.make + " " + foundCar.model);
//*******************************************
//Add a new Car to the database
//*******************************************
//Make an instance of a new car
Car newCarToAdd = new Car();
//Assign properties to the parts of the model
newCarToAdd.id = "88888";
newCarToAdd.make = "Nissan";
newCarToAdd.model = "GT-R";
newCarToAdd.horsepower = 550;
newCarToAdd.cylinders = 8;
newCarToAdd.year = "2016";
newCarToAdd.type = "Car";
//Use a try catch to ensure that they can't add a car with an id that already exists
try
{
//Add the new car to the Cars Collection
carsTestEntities.Cars.Add(newCarToAdd);
//This method call actually does the work of saving the changes to the database
carsTestEntities.SaveChanges();
}
catch (Exception e)
{
//Remove the new car from the Cars Collection since we can't save it.
carsTestEntities.Cars.Remove(newCarToAdd);
Console.WriteLine("Can't add the record. Already have one with that primary key");
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Just added a new car. Going to fetch it and print it to verify");
carToFind = carsTestEntities.Cars.Find("88888");
Console.WriteLine(carToFind.id + " " + carToFind.make + " " + carToFind.model);
//**********************************************
//How to do an update
//**********************************************
//Get a car out of the database that we would like update
Car carToFindForUpdate = carsTestEntities.Cars.Find("88888");
//Output the car to find
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("About to do an update on a car.");
Console.WriteLine(carToFindForUpdate.id + " " + carToFindForUpdate.make +
" " + carToFindForUpdate.model);
Console.WriteLine("Doing the update now");
//Update some of the properties of the car we found. Don't need to update all of
//them if we don't want to. I choose these 4.
carToFindForUpdate.make = "Nissan";
carToFindForUpdate.model = "GT-RRRRRRR";
carToFindForUpdate.horsepower = 1250;
carToFindForUpdate.cylinders = 16;
//Save the changes to the database. Since when we pulled out the one to update, all
//we were really doing was getting a reference to the one in the collection we
//wanted to update. There is no need to 'put' the car back into the Cars collection.
//It is still there. All we have to do is save the changes.
carsTestEntities.SaveChanges();
//Get a car out of the database that we just updated. This will ensure that our
//save actually saved our changes
carToFindForUpdate = carsTestEntities.Cars.Find("88888");
//Output the updated car
Console.WriteLine("Outputing the updated car that was retrived from the db");
Console.WriteLine(carToFindForUpdate.id + " " + carToFindForUpdate.make +
" " + carToFindForUpdate.model);
//*******************************************************
//How to do a delete
//*******************************************************
//Get a car out of the database that we would like to delete
Car carToFindForDelete = carsTestEntities.Cars.Find("88888");
//Remove the Car from the Cars collection
carsTestEntities.Cars.Remove(carToFindForDelete);
//Save the changes to the database
carsTestEntities.SaveChanges();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Deleted the added car. Looking to see if it is still in the DB");
//Try to get the car out of the database, and print it out.
try
{
carToFindForDelete = carsTestEntities.Cars.Find("88888");
Console.WriteLine(carToFindForDelete.id + " " + carToFindForDelete.make +
" " + carToFindForDelete.model);
}
catch (Exception e) //Not in the database.
{
Console.WriteLine("The model you are looking for does not exist " +
e.ToString() + " " + e.StackTrace);
}
//Also going to see if we can do a test for null instead of using a try catch.
if (carToFindForDelete == null)
{
Console.WriteLine("Yes we can do a test for null as well");
}
}
static void Main(string[] args)
{
/*
AdventureWorks2012Entities adventure = new AdventureWorks2012Entities();
int counter = 0;
Guid id = Guid.NewGuid();
foreach (Person person in adventure.People)
{
if (counter == 0)
{
id = person.rowguid;
}
if (counter++ > 20)
{
break;
}
Console.WriteLine(person.FirstName + " " + person.LastName + " " + person.rowguid);
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine(adventure.People.Find(id));
*/
/*
foreach (EmailAddress email in adventure.EmailAddresses)
{
Console.WriteLine(email);
}
*/
//************************************************************
//List out all of the cars in the table
//************************************************************
//Gets access to the collection of tables we can interact with.
CarsTestEntities carsTestEntities = new CarsTestEntities();
Console.WriteLine("Print the list");
//Loop through all of the cars in the table called Cars.
foreach (Car car in carsTestEntities.Cars)
{
Console.WriteLine(car.id + " " + car.make + " " + car.model);
}
//*************************************************************
//Find a specific one by any property
//*************************************************************
//Call the Where method on the table Cars and pass in a lambda expression for
//the criteria we are looking for. There is nothing special about the work car
//in the part that reads: car => car.id == "v0...". It could be any characters we
//want it to be. car made sense. Also, car represents the object we want to do
//the where clause on. That's why we have car.id == "V0..".
Car carToFind = carsTestEntities.Cars.Where(car => car.id == "V0LCD1814").First();
//We can look for a specific model from the database with a where clause based on any
//criteria we want. Here we are doing it with the Car's model instead of it's id..
Car otherCarToFind = carsTestEntities.Cars.Where(car => car.model == "Challenger").First();
//Print them out.
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Find 2 specific cars");
Console.WriteLine(carToFind.id + " " + carToFind.make + " " + carToFind.model);
Console.WriteLine(otherCarToFind.id + " " + otherCarToFind.make + " " + otherCarToFind.model);
//**************************************************************************************
//Find a car based on the primary Id
//**************************************************************************************
//Pull out a car from the table based on the primary Id
Car foundCar = carsTestEntities.Cars.Find("V0LCD1814");
//Print it out
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Print out a found car using the Find method");
//TODO: uncomment when primary id is fixed
Console.WriteLine(foundCar.id + " " + foundCar.make + " " + foundCar.model);
//*************************************************************************************
//Add a new Car to the database
//*************************************************************************************
//Make an instance of a new car
Car newCarToAdd = new Car();
//Assign properties to the parts of the model
newCarToAdd.id = "88888";
newCarToAdd.make = "Nissan";
newCarToAdd.model = "GT-R";
newCarToAdd.horsepower = 550;
newCarToAdd.cylinders = 8;
newCarToAdd.year = "2016";
newCarToAdd.type = "Car";
//Add the new car to the Cars table
carsTestEntities.Cars.Add(newCarToAdd);
//This method call actually does the work of saving the changes to the database
carsTestEntities.SaveChanges();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Add a car and verify it is there");
carToFind = carsTestEntities.Cars.Find("88888");
Console.WriteLine(carToFind.id + " " + carToFind.make + " " + carToFind.model);
//*******************************************************************************
//How to do an update
//*******************************************************************************
//Get a car out of the database that we would like to update
Car carToFindForUpdate = carsTestEntities.Cars.Find("V0LCD1814");
//Update some of the properties of the car we found. Don't need to update all of them
//if we don't want to. I choose these 4.
carToFindForUpdate.make = "Nissan";
carToFindForUpdate.model = "GT-R";
carToFindForUpdate.horsepower = 550;
carToFindForUpdate.cylinders = 8;
//Save the changes to the database
carsTestEntities.SaveChanges();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Update a car with data");
Console.WriteLine(carToFindForUpdate.id + " " + carToFindForUpdate.make + " " + carToFindForUpdate.model);
//*******************************************************************************
//How to do a delete
//*******************************************************************************
//Get a car out of the database that we would like to update
Car carToFindForDelete = carsTestEntities.Cars.Find("88888");
//Remove the Car from the Cars table
carsTestEntities.Cars.Remove(carToFindForDelete);
//Save the changes to the database
carsTestEntities.SaveChanges();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Deleted the added car. Looking to see if it is still in the DB");
try
{
carToFindForDelete = carsTestEntities.Cars.Find("88888");
Console.WriteLine(carToFindForDelete.id + " " + carToFindForDelete.make + " " + carToFindForDelete.model);
}
catch (Exception e)
{
Console.WriteLine("The model you are looking for does not exist");
}
}
static void Main(string[] args)
{
//Make new instance of the Cars Collection
//Probably going to be CarsFInitialLName for you.
CarsTestEntities carsTestEntities = new CarsTestEntities();
//*************************************************
//List out all of the cars in the table
//*************************************************
Console.WriteLine("Print the list");
foreach (Car car in carsTestEntities.Cars)
{
Console.WriteLine(car.id + " " + car.make + " " + car.model);
}
//************************************
//Find a specific one by any property
//************************************
//Call the Where method on the table Cars and pass in a lambda expression
//for the criteria we are looking for. There is nothing special about the
//word car in the part that reads: car => car.id == "V0...". It could be
//any characters we want it to be.
//It is just a variable name for the current car we are considering
//in the expression. This will automagically loop through all the Cars,
//and run the expression against each of them. When the result is finally
//true, it will return that car.
Car carToFind = carsTestEntities.Cars.Where(
car => car.id == "V0LCD1814").First();
//We can look for a specific model from the database with a where based
//on any criteria we want. Here is one the is looking to match the Car's
//model instead of the id.
Car otherCarToFind = carsTestEntities.Cars.Where(
foocar => foocar.model == "Challenger").First();
//Print the cars out
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Find 2 specific cars with Where method");
Console.WriteLine(carToFind.id + " " + carToFind.make + " " + carToFind.model);
Console.WriteLine(otherCarToFind.id + " " + otherCarToFind.make + " " + otherCarToFind.model);
//***************************************************
//Find a car based on the primary key
//***************************************************
//Pull out a car from the table based on the id which is the primary key
//If the record doesn't exist in the database, it will return null, so check
//what you get back and see if it is null. If so, it doesn't exist.
Car foundCar = carsTestEntities.Cars.Find("V0LCD1814");
//Print the cars out
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Find 1 more car by Find method and primary id");
Console.WriteLine(foundCar.id + " " + foundCar.make + " " + foundCar.model);
//***************************************
//Add a new Car to the database
//***************************************
//Make an instance of a new car
Car newCarToAdd = new Car();
//Assign properties to the parts of the model
newCarToAdd.id = "88888";
newCarToAdd.make = "Nissan";
newCarToAdd.model = "GT-R";
newCarToAdd.horsepower = 550;
newCarToAdd.cylinders = 8;
newCarToAdd.year = "2017";
newCarToAdd.type = "Car";
//Use a try catch to ensure that they can't add a car with an id that
//already exists
try
{
//Add the new car to the Cars Collection
carsTestEntities.Cars.Add(newCarToAdd);
//This method call actually does the work of saving the changes to the database
carsTestEntities.SaveChanges();
}
catch (Exception e)
{
//Remove the new car from the Cars Collection since we can't save it
carsTestEntities.Cars.Remove(newCarToAdd);
Console.WriteLine("Can't add the record. Already have one with that primary key");
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Just added a new car. Going to fetch it and print it to verify");
carToFind = carsTestEntities.Cars.Find("88888");
Console.WriteLine(carToFind.id + " " + carToFind.make + " " + carToFind.model);
//*********************************
//How to do an update
//*********************************
//*********************************
//How to do a delete
//*********************************
//Get a car out of the database that we want to delete
Car carToFindForDelete = carsTestEntities.Cars.Find("88888");
//Remove the Car from the Cars Collection
carsTestEntities.Cars.Remove(carToFindForDelete);
//Save the changes to the database
carsTestEntities.SaveChanges();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Deleted the added car. Looking to see if it is still in the db");
//Try to get the car out of the database, and print it out
carToFindForDelete = carsTestEntities.Cars.Find("88888");
if (carToFindForDelete == null)
{
Console.WriteLine("The model you are looking for does not exist");
}
}