public void Test1()
{
using (var db = ApplicationDbScope.UseDefault())
using (var context = ApplicationDbContext.UseMySql())
{
var item = new LS_Provider
{
Password = "******",
NameModel = new NameModel {
Name = "Jack", NickName = "zmjack"
}
};
context.LS_Providers.Add(item);
context.SaveChanges();
var password = db.SqlQuery($"SELECT Password FROM LS_Providers;").ToArray().First()[nameof(LS_Provider.Password)];
Assert.Equal("MDQxNg==", password);
var nameModel = db.SqlQuery($"SELECT NameModel FROM LS_Providers;").ToArray().First()[nameof(LS_Provider.NameModel)];
Assert.Equal(@"{""Name"":""Jack"",""NickName"":""zmjack""}", nameModel);
var record = context.LS_Providers.First();
Assert.Equal("0416", record.Password);
Assert.Equal("Jack", record.NameModel.Name);
Assert.Equal("zmjack", record.NameModel.NickName);
context.LS_Providers.Remove(item);
context.SaveChanges();
}
}
public void Test1()
{
using var db = ApplicationDbScope.UseDefault();
using var context = ApplicationDbContext.UseMySql();
string GetPassword() => db.SqlQuery($"SELECT Password FROM LS_Providers;").First()[nameof(LS_Provider.Password)].ToString();
string GetNameModel() => db.SqlQuery($"SELECT NameModel FROM LS_Providers;").First()[nameof(LS_Provider.NameModel)].ToString();
context.LS_Providers.Delete(x => true);
context.SaveChanges();
var item = new LS_Provider
{
Password = "******",
NameModel = new NameModel {
Name = "Jack", NickName = "zmjack"
}
};
context.LS_Providers.Add(item);
context.SaveChanges();
Assert.Equal("MDQxNg==", GetPassword());
Assert.Equal(@"{""Name"":""Jack"",""NickName"":""zmjack"",""Tag"":null}", GetNameModel());
var record = context.LS_Providers.First();
Assert.Equal("0416", record.Password);
Assert.Equal("Jack", record.NameModel.Name);
Assert.Equal("zmjack", record.NameModel.NickName);
item.Password = "******";
context.SaveChanges();
Assert.Equal("MTIwNDE2", GetPassword());
item.NameModel.Tag = "Hi there.";
context.SaveChanges();
Assert.Equal(@"{""Name"":""Jack"",""NickName"":""zmjack"",""Tag"":""Hi there.""}", GetNameModel());
context.LS_Providers.Delete(x => true);
context.SaveChanges();
}