public void Init() { var options = new MyStaging.Metadata.StagingOptions("MySql", ConstantUtil.MYSQL_CONNECTION); var context = new MySqlDbContext(options); Assert.NotNull(context.User); }
public void Transaction() { var options = new MyStaging.Metadata.StagingOptions("MySql", ConstantUtil.MYSQL_CONNECTION); var context = new MySqlDbContext(options); context.BeginTransaction(); Assert.Single(context.Trans); context.CommitTransaction(); Assert.Equal(0, context.Trans.Keys.Count); context.BeginTransaction(); Assert.Single(context.Trans); context.RollBackTransaction(); Assert.Equal(0, context.Trans.Keys.Count); }
public void Visit() { var options = new MyStaging.Metadata.StagingOptions("MySql", ConstantUtil.MYSQL_CONNECTION); var context = new MySqlDbContext(options); Expression <Func <UserModel, bool> > predicate = (f) => f.Id == 1; DbExpressionVisitor exp = new DbExpressionVisitor { TypeMaster = typeof(UserModel), AliasMaster = "a", AliasUnion = null }; exp.Visit(predicate); var sql = exp.SqlText.Builder.ToString(); testOutput.WriteLine(sql); Assert.StartsWith("(a.Id = @", sql); var count = exp.SqlText.Parameters.Count; Assert.Equal(1, count); predicate = (f) => f.Id == 1 && f.IP == "127.0.0.1"; exp = new DbExpressionVisitor { TypeMaster = typeof(UserModel), AliasMaster = "a", AliasUnion = null }; exp.Visit(predicate); sql = exp.SqlText.Builder.ToString(); testOutput.WriteLine(sql); Assert.StartsWith("((a.Id = @", sql); Assert.EndsWith("))", sql); count = exp.SqlText.Parameters.Count; Assert.Equal(2, count); }