ADO NET SQL Cheat Sheet

using System;
using System.Data.SqlClient;
namespace Initial_Setup
{
    class Program
    {
        const string SqlConnectionString = "Server = .; " +
                                           "Database = master;" + // after create database should be changed
                                           "Integrated Security = True;";
        static void Main(string[] args)
        {
            var connection = new SqlConnection(SqlConnectionString);

            using (connection)
            {
                connection.Open();

                // create database

               string createDatabase = "create database MinionsDB";

               ExecuteNonQuery(connection, createDatabase);

                // create tables

               var createTables = GetCreateStatement(); // returns string []

                foreach (var query in createTables)
                {
                    ExecuteNonQuery(connection, query);
                }

                 //insert into tables

                var insertStatements = InsertDataStatements();

                foreach (var query in insertStatements)
                {
                    ExecuteNonQuery(connection, query);
                }
            }
        }

        private static string[] InsertDataStatements()
        {
            var result = new string[]
            {
            "insert into Countries (Id, Name) values (1,'Bulgaria'),(2,'Norway'),(3,'Cyprus'),(4,'Greece'),(5,'UK')",
            "insert into Towns (Id,Name, CountryCode) values (1,'Plovdiv',1), (2,'Oslo', 2), (3,'Larnaca',3),(4,'Athens',4),(5,'London',5)",
            "insert into Minions (Id,Name, Age, TownId) values (1,'Petar',45, 1 ), (2,'George',22,2), (3,'Jorgos', 22,3), (4,'Mihalis', 35 ,4), (5,'John',65,5)",
            "insert into EvilnessFactors (Id,Name) values (1,'super good'),(2,'good'),(3,'bad'),(4,'evil'),(5,'super evil')",
            "insert into Villains (Id,Name, EvilnessFactorId) values (1,'Gru',1),(2,'Ivo',2),(3,'Teo',3),(4,'Sto',4),(5,'Pro',5)",
            "insert into MinionsVillains (MinionId, VillainId) values (1,1),(2,2),(3,3),(4,4),(5,5)"
            };
            return result;

        }
        private static void ExecuteNonQuery(SqlConnection connection, string query)
        {
            var createCommand = new SqlCommand(query, connection);
            using (createCommand)
            {
                createCommand.ExecuteNonQuery();
            }
        }

        private static string[] GetCreateStatement()
        {
            var result = new string[]
            {
            "create table Countries(Id int primary key, Name varchar(50))",
            "create table Towns (Id int primary key, Name varchar(50), CountryCode int foreign key references Countries(Id))",
            "create table Minions (Id int primary key , Name varchar(50), Age int, TownId int foreign key references Towns (Id) )",
            "create table EvilnessFactors (Id int primary key, Name varchar(50))",
            "create table Villains(Id int primary key, Name varchar(50),EvilnessFactorId int foreign key references EvilnessFactors(Id))",
            "create table MinionsVillains(MinionId int foreign key references Minions(Id), VillainId int foreign key references VillaIns(Id), constraint Minions_Villains primary key (MinionId, VillainId))"
            };

            return result;
        }


    }
}