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");
        }
Example #2
0
 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");
 }