static void GenerateDB()
{
using (CustomerOrderContext db = new CustomerOrderContext())
{
if (db.Database.EnsureCreated())
{
if (!db.Customers.Any())
{
Customer c = new Customer {
FirstName = "Sam", LastName = "Peter", UserName = "******", City = "Redmond", Street = "156 AVE"
};
Order o = new Order {
Price = 99
};
c.Order = o;
db.Customers.Add(c);
db.Orders.Add(o);
c = new Customer {
FirstName = "Keruui", LastName = "Xu", UserName = "******", City = "Bellevue", Street = "Main AVE"
};
o = new Order {
Price = 199
};
c.Order = o;
db.Customers.Add(c);
db.Orders.Add(o);
db.SaveChanges();
}
}
}
}
static void Main(string[] args)
{
GenerateDB();
Console.WriteLine("==========================================");
using (CustomerOrderContext db = new CustomerOrderContext())
{
var aa = db.Customers.Select(e => new CusomterDto {
FullName = e.FirstName + " " + e.LastName
});
foreach (var a in aa)
{
Console.WriteLine(a.FullName);
}
}
Console.WriteLine("==========================================");
using (CustomerOrderContext db = new CustomerOrderContext())
{
var aa = db.Customers.Take(1).Select(e => new CusomterDto {
FullName = e.FirstName + " " + e.LastName
});
foreach (var a in aa)
{
Console.WriteLine(a.FullName);
}
}
Console.WriteLine("==========================================");
using (CustomerOrderContext db = new CustomerOrderContext())
{
var aa = db.Customers.Select(e => new Customer
{
FirstName = e.FirstName,
LastName = e.LastName,
UserName = e.UserName
})
.Take(1).Select(e => new CusomterDto {
FullName = e.FirstName + " " + e.LastName
});
foreach (var a in aa)
{
Console.WriteLine(a.FullName);
}
}
Console.WriteLine("==========================================");
using (CustomerOrderContext db = new CustomerOrderContext())
{
var aa = db.Customers.Select(e => new Customer
{
FirstName = e.FirstName,
LastName = e.LastName,
UserName = e.UserName
})
.Select(e => new CusomterDto {
FullName = e.FirstName + " " + e.LastName
}).Take(1);
foreach (var a in aa)
{
Console.WriteLine(a.FullName);
}
}
Console.WriteLine("Done");
}
