public static void Main()
{
using (var connection = new SqlConnection(Configuration.connectionParams))
{
connection.Open();
var query = Statments.ExerciseTwo();
using (var command = new SqlCommand(query, connection))
{
var reader = command.ExecuteReader();
while (reader.Read())
{
var villain = (string)reader["Name"];
var minnionsCount = (int)reader["MinionsCount"];
Console.WriteLine(villain + " - " + minnionsCount);
}
}
}
}
public static void Main()
{
var connParams = "Server=.; Integrated Security=true;";
using (var connection = new SqlConnection(connParams))
{
connection.Open();
var querry = "create database MinionsDB";
TryExecute(querry, connection);
}
using (var connection = new SqlConnection(Configuration.connectionParams))
{
connection.Open();
var queries = Statments.CreateStatments();
foreach (var querry in queries)
{
TryExecute(querry, connection);
}
}
}
