public static void GetObjectValueTest() { StringBuilder sbCreateTableSql = new StringBuilder(); //附属信息 sbCreateTableSql.Append("Create table ControllerAttachedInfo2(ID integer not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));"); string strDBFile = "E:\\test.db"; //_logHelper = Substitute.For<SCA.Interface.ILogRecorder>(); //_fileService = new SCA.BusinessLib.Utility.FileService(); _dbConn = new SCA.DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService); _dbConn.ExecuteBySql(sbCreateTableSql); int intControllerAttachedInfoNum = Convert.ToInt16(_dbConn.GetObjectValue(new StringBuilder("select count(*) from Co9ntrollerAttachedInfo2"))); _dbConn.Dispose(); }
public void Dipsose() { Console.WriteLine("TearDown"); _dbConn.Dispose(); _fileService.DeleteFile(strDBFile); }