public void GetDataListBySQLTest()
{
IList <LoopModel> lstLoopModel = new List <LoopModel>();
StringBuilder sbCreateTableSql = new StringBuilder();
//回路信息
sbCreateTableSql.Append("Create table Loop(id integer not null primary key autoincrement,name varchar(20),Code varchar(6),controllerID int,DeviceAmount int );");
_dbConn = new DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
_dbConn.ExecuteBySql(sbCreateTableSql);
_dbConn.ExecuteBySql(new StringBuilder("insert into Loop(id,name,Code,controllerID,DeviceAmount) values(1,'william','0101',1,55)"));
lstLoopModel = (List <LoopModel>)_dbConn.GetDataListBySQL <SCA.Model.LoopModel>(new StringBuilder("select * from Loop"));
Assert.AreEqual(1, lstLoopModel.Count);
}
