static void Main(string[] args) { //if (new String("Bob".ToCharArray()) == new String("Bob".ToCharArray())) // Console.WriteLine("Really?"); using (var db = new SchoolDbContext4()) { //var david = db.People.Include(p=>p.Cars) //loads Cars despite lazy loading // .FirstOrDefault(p => p.First.StartsWith("Dav")); //if (david == null) //{ // // log //} //david.Cars.Add(new Car {Color = Color.Green, Make = "Ferrarri", Model = "912"}); //david.First = "Dave"; // EF tracks changes and will save them var c = new Car() { Color = Color.Lavender }; db.Cars.Add(c); db.SaveChanges(); // Console.WriteLine(david); } }
static void AddPerson(Person p2) { Person p = new Person { First = "David", Last = "Langstein", }; p.Cars = new List <Car>(); p.Cars.Add(new Car { Color = Color.Algerian, Make = "Mazda", Model = "911" }); using (var db = new SchoolDbContext4()) { db.People.Add(p); db.SaveChanges(); } }
static void Main2(string[] args) { using (var db = new SchoolDbContext4()) { Console.WriteLine(db.People.Count()); // on first access will create database //for (int i = 0; i < 10; i++) //{ // var p = new Person // { // First = "Abe", // Last = "Lincoln", // Suffix = i + 1 + "" // }; // db.People.Add(p); //} //db.SaveChanges(); Console.WriteLine(db.People.Count()); // on first access will create database var AnonObjectList = db.People .Select(p222 => new { FullName = p222.Last + ", " + p222.First, Suffix = p222.Suffix, Useless = 5 }).ToList(); foreach (var qqqq in AnonObjectList) { Console.WriteLine(qqqq.FullName); } //var _3ers = db.People // .Where(p => p.Suffix.ToCharArray().Length == 1); // will fail since when LINQ query is realized it will be converted to SQL, and SQL does not support toCharArray //foreach (var p in _3ers) //{ // Console.WriteLine(p.Suffix); //} Console.ReadLine(); } }