示例#1
0
        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}");
 }