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); } } }