static void QueryWithEF_SQL()
{
var context = new Myefc_DB2Context();
var data = context.Customers.FromSqlRaw(@"SELECT * FROM Customers").AsNoTracking().ToList();
Console.WriteLine(data.Count());
}
static void QueryWithEF()
{
var context = new Myefc_DB2Context();
var data = context.Customers.ToList();
Console.WriteLine(data.Count());
}
static void QueryWithEF_SQL2()
{
var context = new Myefc_DB2Context();
var conn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=MyEFC_DB2;Integrated Security=True;Connect Timeout=30;Encrypt=False");
var data = conn.FromSQLRaw5 <Customers>(@"SELECT * FROM Customers");
Console.WriteLine(data.Count());
}
static void QueryWithEF_NoTrack()
{
var context = new Myefc_DB2Context();
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var data = context.Customers.AsNoTracking().ToList();
Console.WriteLine(data.Count());
}
static void GenerateCustomersV1()
{
var context = new Myefc_DB2Context();
context.Database.EnsureCreated();
const string characters = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
var random = new Random();
for (int i = 0; i < 100000; i++)
{
context.Customers.Add(new Customers()
{
Name = new string(Enumerable.Repeat(characters, 10).Select(a => a[random.Next(a.Length)]).ToArray()),
Credit_Level = random.Next(5)
});
}
context.SaveChanges();
}