public void ConnectionTest() { SqlService.OpenConnection(); SqlService.DropTable("users"); SqlService.CreateModelTable("users"); var users = SqlService.ExecuteSql("select * from users limit 1;"); while (users.Read()) { var project = new Project() { Name = users.GetString(1), // Type = int.Parse(projectsDB.GetString(2)) }; Console.Out.WriteLine(" {0} {1}", users.GetString(1), users.GetString(2)); } SqlService.CloseConnection(); }
public static void CreateTransient(string tableName) { SqlService.OpenConnection(); SqlService.DropTable($"{tableName}"); SqlService.CreateModelTable($"{tableName}"); }