private static void InitializeAndSeedSqliteDatabase()
{
MySqliteDbContext.EnsureDatabaseIsCleaned();
using var dbContext = new MySqliteDbContext();
dbContext.Database.Migrate();
var seed = JsonSerializer.Deserialize <Customer[]>(
File.ReadAllText(Path.Combine(@"customers.json")),
new JsonSerializerOptions
{
PropertyNamingPolicy = JsonNamingPolicy.CamelCase
});
dbContext.Customers.AddRange(seed);
dbContext.SaveChanges();
}
private static void Main()
{
//InitializeAndSeedSqliteDatabase(); // only need it for SQLite, the first time for seeding data
using var dbContext = new MySqliteDbContext();
//InitializeAndSeedSqlServerDatabase(); // only need it for SQL Server, the first time for seeding data
//using var dbContext = new MySqlServerDbContext();
Logger.LogInformation("\r\n========================================================================\r\n");
//var s0 = dbContext.Customers.Where(x=> x.LastName.StartsWith("pe", StringComparison.CurrentCultureIgnoreCase)).ToList();
var startsWith1 = dbContext.Customers.Where(x => x.LastName.StartsWith("pe")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", startsWith1));
Logger.LogInformation("\r\n========================================================================\r\n");
var startsWith2 = dbContext.Customers.Where(x => x.LastName.ToLower().StartsWith("pe")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", startsWith2));
Logger.LogInformation("\r\n========================================================================\r\n");
var startsWith3 = dbContext.Customers.Where(x => x.LastName.StartsWith("Pe")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", startsWith3));
Logger.LogInformation("\r\n========================================================================\r\n");
var contains1 = dbContext.Customers.Where(x => x.LastName.Contains("pe")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", contains1));
Logger.LogInformation("\r\n========================================================================\r\n");
var contains2 = dbContext.Customers.Where(x => x.LastName.ToLower().Contains("pe")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", contains2));
Logger.LogInformation("\r\n========================================================================\r\n");
var contains3 = dbContext.Customers.Where(x => x.LastName.Contains("Pe")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", contains3));
Logger.LogInformation("\r\n========================================================================\r\n");
var equals1 = dbContext.Customers.Where(x => x.LastName.Equals("perez")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", equals1));
Logger.LogInformation("\r\n========================================================================\r\n");
var equals2 = dbContext.Customers.Where(x => x.LastName.ToLower().Equals("perez")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", equals2));
Logger.LogInformation("\r\n========================================================================\r\n");
var equals3 = dbContext.Customers.Where(x => x.LastName.Equals("Perez")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", equals3));
Logger.LogInformation("\r\n========================================================================\r\n");
var equals4 = dbContext.Customers.Where(x => x.LastName == "perez").Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", equals4));
Logger.LogInformation("\r\n========================================================================\r\n");
var equals5 = dbContext.Customers.Where(x => x.LastName.ToLower() == "perez").Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", equals5));
Logger.LogInformation("\r\n========================================================================\r\n");
var equals6 = dbContext.Customers.Where(x => x.LastName == "Perez").Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", equals6));
Logger.LogInformation("\r\n========================================================================\r\n");
Logger.LogInformation("\r\nLIKE Operator\r\n");
var like1 = dbContext.Customers.Where(x => EF.Functions.Like(x.LastName, "pe%")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", like1));
Logger.LogInformation("\r\n========================================================================\r\n");
var like2 = dbContext.Customers.Where(x => EF.Functions.Like(x.LastName.ToLower(), "pe%")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", like2));
Logger.LogInformation("\r\n========================================================================\r\n");
var like3 = dbContext.Customers.Where(x => EF.Functions.Like(x.LastName, "Pe%")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", like3));
Logger.LogInformation("\r\n========================================================================\r\n");
var like4 = dbContext.Customers.Where(x => EF.Functions.Like(x.LastName, "%pe%")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", like4));
Logger.LogInformation("\r\n========================================================================\r\n");
var like5 = dbContext.Customers.Where(x => EF.Functions.Like(x.LastName.ToLower(), "%pe%")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", like5));
Logger.LogInformation("\r\n========================================================================\r\n");
var like6 = dbContext.Customers.Where(x => EF.Functions.Like(x.LastName, "%Pe%")).Select(x => x.LastName).ToList();
Logger.LogInformation(string.Join("\t", like6));
Logger.LogInformation("\r\n========================================================================\r\n");
}
