private void CreateTables()
{
SqlServerUtility.AddTable(_connection, "tblFolderPath",
"CREATE TABLE tblFolderPath ( idPath int IDENTITY(1,1) NOT NULL, strPath varchar(2048))");
SqlServerUtility.AddPrimaryKey(_connection, "tblFolderPath", "idPath");
SqlServerUtility.AddTable(_connection, "tblFolderSetting",
"CREATE TABLE tblFolderSetting ( idSetting int IDENTITY(1,1) NOT NULL, idPath int NOT NULL, tagName varchar(2048), tagValue varchar(2048))");
SqlServerUtility.AddPrimaryKey(_connection, "tblFolderSetting", "idSetting");
}
private void CreateTables()
{
SqlServerUtility.AddTable(_connection, "tblPicture",
"CREATE TABLE tblPicture ( idPicture int IDENTITY(1,1) NOT NULL, strFile varchar(2048), iRotation int, strDateTaken datetime)");
SqlServerUtility.AddPrimaryKey(_connection, "tblPicture", "idPicture");
}