private Task ClearAsync() { var factory = new DbProviderFactoriesSample(); var expression = "DELETE FROM Names"; var connection = factory.GetConnection(); //var task = connection.OpenAsync(); //using (var connection2 = factory.GetConnection()) //{ // connection2.OpenAsync().ContinueWith(_ => // { // var clearCommand = connection2.CreateCommand(); // clearCommand.CommandText = expression; // clearCommand.ExecuteNonQuery(); // }); //} return(connection.OpenAsync().ContinueWith(_ => { var clearCommand = connection.CreateCommand(); clearCommand.CommandText = expression; clearCommand.ExecuteNonQuery(); connection.Close(); })); }
private Task FillAsync(int iterations) { var factory = new DbProviderFactoriesSample(); var expression = ""; var task = Task.Run(() => { var insertRaw = "INSERT INTO Names(Name) VALUES('Vlad') "; expression = ""; for (int i = 0; i < iterations; i++) { expression += insertRaw; } }).ContinueWith(t => { var connection = factory.GetConnection(); connection.OpenAsync().ContinueWith(_ => { var fillCommand = connection.CreateCommand(); fillCommand.CommandText = expression; fillCommand.ExecuteNonQuery(); }); }); return(task); }
private Task ReadAsync(IList <NameViewModel> names) { var factory = new DbProviderFactoriesSample(); var expression = "SELECT * FROM Names"; var connection = factory.GetConnection(); return(connection.OpenAsync().ContinueWith(_ => { var readCommand = connection.CreateCommand(); readCommand.CommandText = expression; readCommand.ExecuteReaderAsync().ContinueWith(t => { while (t.Result.Read()) { Application.Current.Dispatcher.Invoke(() => { names.Add(new NameViewModel { Id = t.Result.GetInt32(0), Name = t.Result.GetString(1) }); }); //names.Add(new NameViewModel //{ // Id = t.Result.GetInt32(0), // Name = t.Result.GetString(1) //}); } connection.Close(); } ); })); }
private void Clear() { var factory = new DbProviderFactoriesSample(); var expression = "DELETE FROM Names"; using (var connection = factory.GetConnection()) { connection.Open(); var clearCommand = connection.CreateCommand(); clearCommand.CommandText = expression; clearCommand.ExecuteNonQuery(); } }
private void Read() { var factory = new DbProviderFactoriesSample(); var expression = "SELECT * FROM Names"; using (var connection = factory.GetConnection()) { connection.Open(); var readCommand = connection.CreateCommand(); readCommand.CommandText = expression; var reader = readCommand.ExecuteReader(); while (reader.Read()) { Console.WriteLine($"ID: {reader.GetInt32(0)}\tName: {reader.GetString(1)}"); } } }
private void Fill(int iterations) { var factory = new DbProviderFactoriesSample(); var insertRaw = "INSERT INTO Names(Name) VALUES('Vlad') "; var expression = ""; for (int i = 0; i < iterations; i++) { expression += insertRaw; } using (var connection = factory.GetConnection()) { connection.Open(); var fillCommand = connection.CreateCommand(); fillCommand.CommandText = expression; fillCommand.ExecuteNonQuery(); } }
private void Read(IList <NameViewModel> names) { var factory = new DbProviderFactoriesSample(); var expression = "SELECT * FROM Names"; using (var connection = factory.GetConnection()) { connection.Open(); var readCommand = connection.CreateCommand(); readCommand.CommandText = expression; var reader = readCommand.ExecuteReader(); while (reader.Read()) { names.Add(new NameViewModel { Id = reader.GetInt32(0), Name = reader.GetString(1) }); } } }
private Task ReadAsync() { var factory = new DbProviderFactoriesSample(); var expression = "SELECT * FROM Names"; var connection = factory.GetConnection(); return(connection.OpenAsync().ContinueWith(_ => { completed = true; var readCommand = connection.CreateCommand(); readCommand.CommandText = expression; readCommand.ExecuteReaderAsync().ContinueWith(t => { while (t.Result.Read()) { Console.WriteLine($"ID: {t.Result.GetInt32(0)}\tName: {t.Result.GetString(1)}"); } connection.Close(); } ); })); }