public virtual void Dispose()
{
Utilities.ORM.ORM.Destroy();
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;Pooling=false"))
{
Helper.Batch().AddCommand("ALTER DATABASE ORMTestDatabase3 SET OFFLINE WITH ROLLBACK IMMEDIATE", CommandType.Text)
.AddCommand("ALTER DATABASE ORMTestDatabase3 SET ONLINE", CommandType.Text)
.AddCommand("DROP DATABASE ORMTestDatabase3", CommandType.Text);
Helper.ExecuteNonQuery();
}
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;Pooling=false"))
{
Helper.Batch().AddCommand("ALTER DATABASE ORMTestDatabase2 SET OFFLINE WITH ROLLBACK IMMEDIATE", CommandType.Text)
.AddCommand("ALTER DATABASE ORMTestDatabase2 SET ONLINE", CommandType.Text)
.AddCommand("DROP DATABASE ORMTestDatabase2", CommandType.Text);
Helper.ExecuteNonQuery();
}
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;Pooling=false"))
{
Helper.Batch().AddCommand("ALTER DATABASE ORMTestDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE", CommandType.Text)
.AddCommand("ALTER DATABASE ORMTestDatabase SET ONLINE", CommandType.Text)
.AddCommand("DROP DATABASE ORMTestDatabase", CommandType.Text);
Helper.ExecuteNonQuery();
}
}
public virtual void Dispose()
{
Utilities.ORM.ORM.Destroy();
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;Pooling=false"))
{
Helper.Batch().AddCommand("ALTER DATABASE ORMTestDatabase3 SET OFFLINE WITH ROLLBACK IMMEDIATE", CommandType.Text)
.AddCommand("ALTER DATABASE ORMTestDatabase3 SET ONLINE", CommandType.Text)
.AddCommand("DROP DATABASE ORMTestDatabase3", CommandType.Text);
Helper.ExecuteNonQuery();
}
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;Pooling=false"))
{
Helper.Batch().AddCommand("ALTER DATABASE ORMTestDatabase2 SET OFFLINE WITH ROLLBACK IMMEDIATE", CommandType.Text)
.AddCommand("ALTER DATABASE ORMTestDatabase2 SET ONLINE", CommandType.Text)
.AddCommand("DROP DATABASE ORMTestDatabase2", CommandType.Text);
Helper.ExecuteNonQuery();
}
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Initial Catalog=master;Integrated Security=SSPI;Pooling=false"))
{
Helper.Batch().AddCommand("ALTER DATABASE ORMTestDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE", CommandType.Text)
.AddCommand("ALTER DATABASE ORMTestDatabase SET ONLINE", CommandType.Text)
.AddCommand("DROP DATABASE ORMTestDatabase", CommandType.Text);
Helper.ExecuteNonQuery();
}
}
public void LargeBatchInsert()
{
Guid TempGuid = Guid.NewGuid();
Utilities.SQL.MicroORM.Command TempCommand = new Utilities.SQL.MicroORM.Command("insert into TestTable(StringValue1,StringValue2,BigIntValue,BitValue,DecimalValue,FloatValue,DateTimeValue,GUIDValue) VALUES (@0,@1,@2,@3,@4,@5,@6,@7)", CommandType.Text, "@", "Test String", "Test String", 12345L, true, 1234.5678m, 12345.6534f, new DateTime(1999, 12, 31), TempGuid);
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper(TempCommand, "Data Source=localhost;Initial Catalog=TestDatabase;Integrated Security=SSPI;Pooling=false"))
{
IBatchCommand Batch = Helper.Batch();
for (int x = 0; x < 1000; ++x)
{
Batch.AddCommands(new Utilities.SQL.MicroORM.Command("insert into TestTable(StringValue1,StringValue2,BigIntValue,BitValue,DecimalValue,FloatValue,DateTimeValue,GUIDValue) VALUES (@0,@1,@2,@3,@4,@5,@6,@7)", CommandType.Text, "@", "Test String", "Test String", 12345L, true, 1234.5678m, 12345.6534f, new DateTime(1999, 12, 31), TempGuid));
}
Assert.Throws <SqlException>(() => Helper.ExecuteNonQuery());
}
}
public void LargeBatchInsert()
{
Guid TempGuid = Guid.NewGuid();
Utilities.SQL.MicroORM.Command TempCommand = new Utilities.SQL.MicroORM.Command("insert into TestTable(StringValue1,StringValue2,BigIntValue,BitValue,DecimalValue,FloatValue,DateTimeValue,GUIDValue) VALUES (@0,@1,@2,@3,@4,@5,@6,@7)", CommandType.Text, "@", "Test String", "Test String", 12345L, true, 1234.5678m, 12345.6534f, new DateTime(1999, 12, 31), TempGuid);
using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper(TempCommand, "Data Source=localhost;Initial Catalog=TestDatabase;Integrated Security=SSPI;Pooling=false"))
{
IBatchCommand Batch = Helper.Batch();
for (int x = 0; x < 1000; ++x)
{
Batch.AddCommands(new Utilities.SQL.MicroORM.Command("insert into TestTable(StringValue1,StringValue2,BigIntValue,BitValue,DecimalValue,FloatValue,DateTimeValue,GUIDValue) VALUES (@0,@1,@2,@3,@4,@5,@6,@7)", CommandType.Text, "@", "Test String", "Test String", 12345L, true, 1234.5678m, 12345.6534f, new DateTime(1999, 12, 31), TempGuid));
}
Assert.Throws<SqlException>(() => Helper.ExecuteNonQuery());
}
}
