public void TestCreateTableWithoutDef()
{
INLORMDb mssqlDb = null;
mssqlDb = new NLORMMSSQLDb(ConnectionString);
mssqlDb.CreateTable <TestClass2>();
}
private void insertdata(INLORMDb db)
{
db.Insert<TestClassOne>(new TestClassOne() { Id = "sssss", income = 123456 });
db.Insert<TestClassOne>(new TestClassOne() { Id = "rrrrr", income = 789012 });
db.Insert<TestClassOne>(new TestClassOne() { Id = "fffff", income = 345678 });
db.Insert<TestClassOne>(new TestClassOne() { Id = "lllll", income = 901234 });
db.Insert<TestClassOne>(new TestClassOne() { Id = "alber", income = 901234 });
}
public void TestDropTable()
{
INLORMDb db = null;
db = new NLORMMSSQLDb(ConnectionString);
db.CreateTable <TestClass01>();
db.DropTable <TestClass01>();
}
private void Init(INLORMDb db)
{
try
{
db.DropTable <TestClassUser>();
}
catch { }
db.CreateTable <TestClassUser>();
}
private void createtable(INLORMDb db)
{
try
{
db.DropTable <TestClassOne>();
}
catch { }
db.CreateTable <TestClassOne>();
}
private void createtable(INLORMDb db)
{
try
{
//db.DropTable<TestClassOne>();
db.CreateTable<TestClassOne>();
}
catch (Exception)
{
}
}
private void createtable(INLORMDb db)
{
try
{
//db.DropTable<TestClassOne>();
db.CreateTable <TestClassOne>();
}
catch (Exception)
{
}
}
public void TestQueryMethod1()
{
INLORMDb db = null;
db = new NLORMMSSQLDb(ConnectionString);
this.TestInsertAlotItems();
var result = db.Query <TestClass01>(@"SELECT * FROM TestClass01 where ID = @ID", new TestClass01()
{
ID = @"01"
});
Assert.AreEqual(1, result.Count());
}
private void insertdata(INLORMDb db)
{
db.Insert <TestClassOne>(new TestClassOne()
{
Id = "sssss", income = 123456
});
db.Insert <TestClassOne>(new TestClassOne()
{
Id = "rrrrr", income = 789012
});
db.Insert <TestClassOne>(new TestClassOne()
{
Id = "fffff", income = 345678
});
db.Insert <TestClassOne>(new TestClassOne()
{
Id = "lllll", income = 901234
});
db.Insert <TestClassOne>(new TestClassOne()
{
Id = "alber", income = 901234
});
}
private void createtable( INLORMDb db)
{
db.CreateTable<TestClassOne>();
}
private void createtable(INLORMDb db)
{
db.CreateTable <TestClassOne>();
}
