static void TestDbContext()
{
try
{
WriteToDatabase();
}
catch (Exception ex)
{
var a = ex;
}
void WriteToDatabase()
{
var dbConnectionBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
dbConnectionBuilder.DataSource = "115.159.55.137,1999";
dbConnectionBuilder.UserID = "chenguangxu";
dbConnectionBuilder.Password = "******";
dbConnectionBuilder.InitialCatalog = "Manager.Account";
dbConnectionBuilder.ConnectTimeout = 10;
DbConnectionManager.Register(dbConnectionBuilder.InitialCatalog, new MsSqlConnectionProvider(10, dbConnectionBuilder.ConnectionString));
EntitySchemaManager.LoadEntity(typeof(Entity));
var option = new DbContextOptions();
option.ExceptionHandling = ExceptionHandling.Skip;
using (var dbContext = new DbContext(option))
{
var dbSet = dbContext.Set <Entity>();
dbSet.Add(new Entity()
{
ID = 2, Name = "a2"
});
dbSet.Add(new Entity()
{
ID = 3, Name = "a3"
});
try
{
dbContext.SaveChanges();
}
finally
{
foreach (var row in dbSet.RowEntries)
{
var a = row.State;
}
}
}
}
}
static void TestDatabase()
{
var dbConnectionBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
dbConnectionBuilder.DataSource = "115.159.55.137,1999";
dbConnectionBuilder.UserID = "chenguangxu";
dbConnectionBuilder.Password = "******";
dbConnectionBuilder.InitialCatalog = "Manager.Account";
DbConnectionManager.Register(dbConnectionBuilder.InitialCatalog, new MsSqlConnectionProvider(10, dbConnectionBuilder.ConnectionString));
EntitySchemaManager.LoadEntity(typeof(Entity));
foreach (var view in EntitySchemaManager.Schemas)
{
EntityUtils.CheckSchema(view);
}
}
