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); } }