System.Data.Common.DbCommand.ExecuteNonQueryAsync()

Here are the examples of the csharp api class System.Data.Common.DbCommand.ExecuteNonQueryAsync() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

61 Examples 7

1. Example

Project: DisplayMonkey
Source File: DataAccess.cs
View license
public static async Task ExecuteNonQueryExtAsync(this SqlCommand cmd)
        {
            await ConnectionWrapAsync(cmd, async () => await cmd.ExecuteNonQueryAsync());
        }

2. Example

View license
public async Task<int> ExecuteStatementNoResultAsync(string sqlCommandText, params SqlParameter[] sqlParameters)
        {
            SqlCommand sqlCommand = this.CreateStatementCommand(sqlCommandText, sqlParameters);
            return await sqlCommand.ExecuteNonQueryAsync();
        }

3. Example

Project: learn-azure
Source File: function_code.cs
View license
public static async Task Run(TimerInfo myTimer, TraceWriter log)
{
	var connStr = ConfigurationManager.ConnectionStrings["sqldb"].ConnectionString;

	using (var conn = new SqlConnection(connStr))
	{
		conn.Open();
		var sqlCmd = "DELETE FROM TimelineItems WHERE deleted = 'True'";
		using (var cmd = new SqlCommand(sqlCmd, conn))
		{
			var rows = await cmd.ExecuteNonQueryAsync();
			log.Info($"{rows} rows deleted.");
		}
	}
}

4. Example

Project: DeclarativeSql
Source File: OracleOperation.cs
View license
public override Task<int> BulkInsertAsync<T>(IEnumerable<T> data)
            => this.CreateBulkInsertCommand(data).ExecuteNonQueryAsync();

5. Example

View license
public async Task DeleteAsync(EmployeeClassification classification)
        {
            var sql = @"DELETE HR.EmployeeClassification WHERE EmployeeClassificationKey = @EmployeeClassificationKey;";

            using (var con = new SqlConnection(m_ConnectionString))
            {
                await con.OpenAsync();

                using (var cmd = new SqlCommand(sql, con))
                {
                    cmd.Parameters.AddWithValue("@EmployeeClassificationKey", classification.EmployeeClassificationKey);
                    await cmd.ExecuteNonQueryAsync();
                }
            }
        }

6. Example

View license
public async Task DeleteAsync(int employeeClassificationKey)
        {
            var sql = @"DELETE HR.EmployeeClassification WHERE EmployeeClassificationKey = @EmployeeClassificationKey;";

            using (var con = new SqlConnection(m_ConnectionString))
            {
                await con.OpenAsync();

                using (var cmd = new SqlCommand(sql, con))
                {
                    cmd.Parameters.AddWithValue("@EmployeeClassificationKey", employeeClassificationKey);
                    await cmd.ExecuteNonQueryAsync();
                }
            }
        }

7. Example

View license
public async Task UpdateAsync(EmployeeClassification classification)
        {
            var sql = @"UPDATE HR.EmployeeClassification 
                        SET EmployeeClassificationName = @EmployeeClassificationName 
                        WHERE EmployeeClassificationKey = @EmployeeClassificationKey;";

            using (var con = new SqlConnection(m_ConnectionString))
            {
                await con.OpenAsync();
                using (var cmd = new SqlCommand(sql, con))
                {
                    cmd.Parameters.AddWithValue("@EmployeeClassificationKey", classification.EmployeeClassificationKey);
                    cmd.Parameters.AddWithValue("@EmployeeClassificationName", classification.EmployeeClassificationName);
                    await cmd.ExecuteNonQueryAsync();
                }
            }
        }

8. Example

Project: Opserver
Source File: ExtensionMethods.Sql.cs
View license
public static async Task<int> SetReadUncommittedAsync(this DbConnection connection)
        {
            if (connection == null) throw new ArgumentNullException(nameof(connection));
            using (var cmd = connection.CreateCommand())
            {
                cmd.CommandText = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED";
                await cmd.ExecuteNonQueryAsync().ConfigureAwait(false);
            }
            return 1;
        }

9. Example

View license
public async Task<int> ResetTableAsync(DbConnection connection, bool dropIfExists = false)
        {
            var sql = BuildCreateTableSql(dropIfExists);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

10. Example

View license
public async Task<int> CreateAsync(DbConnection connection, T value, params object[] keyValues)
        {
            var sql = BuildSqlForCreate(value, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

11. Example

View license
public async Task<int> DeleteAsync(DbConnection connection, params object[] keyValues)
        {
            var sql = BuildSqlForDelete(keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

12. Example

View license
public async Task<int> SaveAsync(DbConnection connection, IContainerTracker<T> tracker,
                                         params object[] keyValues)
        {
            var sql = BuildSqlForSave(tracker, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

13. Example

View license
public async Task<int> ResetTableAsync(DbConnection connection)
        {
            var sql = BuildCreateTableSql(true);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

14. Example

View license
public async Task<int> CreateAsync(DbConnection connection, IDictionary<TKey, TValue> dictionary,
                                           params object[] keyValues)
        {
            var sql = BuildSqlForCreate(dictionary, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

15. Example

View license
public async Task<int> DeleteAsync(DbConnection connection, params object[] keyValues)
        {
            var sql = BuildSqlForDelete(keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

16. Example

View license
public async Task<int> SaveAsync(DbConnection connection, TrackableDictionaryTracker<TKey, TValue> tracker,
                                         params object[] keyValues)
        {
            if (tracker.HasChange == false)
                return 0;

            var sql = BuildSqlForSave(tracker, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

17. Example

View license
public async Task<int> ResetTableAsync(DbConnection connection)
        {
            var sql = BuildCreateTableSql(true);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

18. Example

View license
public async Task<int> DeleteAsync(DbConnection connection, params object[] keyValues)
        {
            var sql = BuildSqlForDelete(keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

19. Example

View license
public async Task<int> SaveAsync(DbConnection connection, TrackablePocoTracker<T> tracker,
                                         params object[] keyValues)
        {
            if (tracker.HasChange == false)
                return 0;

            var sql = BuildSqlForSave(tracker, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

20. Example

View license
public async Task<int> ResetTableAsync(DbConnection connection)
        {
            var sql = BuildCreateTableSql(true);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

21. Example

View license
public async Task<int> CreateAsync(DbConnection connection, ICollection<T> set,
                                           params object[] keyValues)
        {
            var sql = BuildSqlForCreate(set, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

22. Example

View license
public async Task<int> DeleteAsync(DbConnection connection, params object[] keyValues)
        {
            var sql = BuildSqlForDelete(keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

23. Example

View license
public async Task<int> SaveAsync(DbConnection connection, TrackableSetTracker<T> tracker,
                                         params object[] keyValues)
        {
            if (tracker.HasChange == false)
                return 0;

            var sql = BuildSqlForSave(tracker, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                return await command.ExecuteNonQueryAsync();
            }
        }

24. Example

Project: Respawn
Source File: Checkpoint.cs
View license
private async Task ExecuteDeleteSqlAsync(DbConnection connection)
        {
            using (var tx = connection.BeginTransaction())
            using (var cmd = connection.CreateCommand())
            {
                cmd.CommandTimeout = CommandTimeout ?? cmd.CommandTimeout;
                cmd.CommandText = _deleteSql;
                cmd.Transaction = tx;

                await cmd.ExecuteNonQueryAsync();

                tx.Commit();
            }
        }

25. Example

Project: SqlServerTimeZoneSupport
Source File: Program.cs
View license
private static async Task WriteLinksAsync(IDictionary<string, int> zones, ILookup<string, string> aliases)
        {
            var cs = _options.ConnectionString;
            using (var connection = new SqlConnection(cs))
            {
                var command = new SqlCommand("[Tzdb].[AddLink]", connection) { CommandType = CommandType.StoredProcedure };
                command.Parameters.Add("@LinkZoneId", SqlDbType.Int);
                command.Parameters.Add("@CanonicalZoneId", SqlDbType.Int);

                await connection.OpenAsync();

                foreach (var alias in aliases)
                {
                    var canonicalId = zones[alias.Key];
                    foreach (var link in alias)
                    {
                        command.Parameters[0].Value = zones[link];
                        command.Parameters[1].Value = canonicalId;
                        await command.ExecuteNonQueryAsync();
                    }
                }

                connection.Close();
            }
        }

26. Example

Project: SqlServerTimeZoneSupport
Source File: Program.cs
View license
private static async Task WriteVersion(string version)
        {
            var cs = _options.ConnectionString;
            using (var connection = new SqlConnection(cs))
            {
                var command = new SqlCommand("[Tzdb].[SetVersion]", connection) { CommandType = CommandType.StoredProcedure };
                command.Parameters.AddWithValue("@Version", version);

                await connection.OpenAsync();
                await command.ExecuteNonQueryAsync();
                connection.Close();
            }
        }

27. Example

View license
public static async Task InsertPurchaseOrderHeaderAsync(string cnStr)
        {
            const st/n ..... /n //View Source file for more details /n }

28. Example

View license
public static async Task LogAsync(string cnStr, string logTableName)
        {
            string queryString = "INSERT INTO dbo." + logTableName + " (LogId, Message, LogTime) VALUES (@LogId, @Message, @LogTime)";

            var logMessage = new LogMessage();

            using (var cn = new SqlConnection(cnStr))
            {
                using (var cmd = new SqlCommand(queryString, cn))
                {
                    cmd.Parameters.AddWithValue("@LogId", logMessage.LogId);
                    cmd.Parameters.AddWithValue("@Message", logMessage.Message);
                    cmd.Parameters.AddWithValue("@LogTime", logMessage.LogTime);

                    await cn.OpenAsync().ConfigureAwait(false);
                    await cmd.ExecuteNonQueryAsync().ConfigureAwait(false);
                }
            }
        }

29. Example

Project: Rxx
Source File: SqlCommandExtensions.cs
View license
public static IObservable<int> ExecuteNonQueryObservable(this SqlCommand command)
    {
      Contract.Requires(command != null);
      Contract.Ensures(Contract.Result<IObservable<int>>() != null);

      return Observable.StartAsync(cancel => command.ExecuteNonQueryAsync(cancel));
    }

30. Example

Project: sensenet
Source File: SqlProcedure.cs
View license
public async Task<int> ExecuteNonQueryAsync()
        {
            using (var op = SnTrace.Database.StartOperation(GetTraceData("ExecuteNonQuery")))
            {
                StartConnection();
                var result = await _cmd.ExecuteNonQueryAsync();
                op.Successful = true;
                return result;
            }
        }

31. Example

View license
public async Task<int> ExecuteNonQueryAsync(SqlCommand cmd, params SqlParameter[] Params)
        {
            try
            {
                if (Transaction != null && Transaction != default(SqlTransaction))
                    cmd.Transaction = Transaction;
                else
                    cmd.Connection = SqlConn;

                if (Params != null && Params.Length > 0)
                {
                    foreach (var param in Params)
                        cmd.Parameters.Add(param);
                }

                await OpenAsync();

                return await cmd.ExecuteNonQueryAsync();
            }
            finally
            {
                Close();
            }
        }

32. Example

View license
public static async Task CreateDatabaseAsync()
            {
                var conn = ConnectionManager.GetDefaultConnection();

                var databaseName = conn.Connection.DatabaseName;
                var masterConn = conn.Connection.Clone() as Connection;
                masterConn.DatabaseName = "master";

                var sqlConn = new SqlConnection(masterConn.ConnectionString);

                // Create a command object identifying the stored procedure
                using (var cmd = sqlConn.CreateCommand())
                {
                    //
                    // Set the command object so it knows to execute a stored procedure
                    cmd.CommandType = CommandType.Text;

                    cmd.CommandText =
                        EmbeddedAssembly.GetFromResources("DatabaseCreatorQuery.sql")
                            .Replace("#DatabaseName", databaseName);
                    //
                    // execute the command
                    try
                    {
                        await sqlConn.OpenAsync();

                        await cmd.ExecuteNonQueryAsync();
                    }
                    finally
                    {
                        sqlConn.Close();
                    }
                }
            }

33. Example

Project: DeclarativeSql
Source File: OracleOperation.cs
View license
public override async Task<long> InsertAndGetAsync<T>(T data)
        {
            This.AssertInsertAndGet<T>();
            var param = this.CreateInsertAndGetParameter(data);
            var result = await param.Item1.ExecuteNonQueryAsync().ConfigureAwait(false);
            if (result != 1)
                throw new SystemException("Affected row count is not 1.");
            return Convert.ToInt64(param.Item2.Value);
        }

34. Example

Project: nhibernate-core
Source File: NullQueryTest.cs
View license
[Test]
		public async Task BadGrammarAsync()
		{
			ISession session = OpenSession();
			var connection = session.Connection;
			try
			{
				var ps = connection.CreateCommand();
				ps.CommandType = CommandType.Text;
				ps.CommandText = "whatever";
				await (ps.ExecuteNonQueryAsync());
			}
			catch (Exception sqle)
			{
				Assert.DoesNotThrow(
					() => ADOExceptionHelper.Convert(Sfi.SQLExceptionConverter, sqle, "could not get or update next value", null));
			}
			finally
			{
				session.Close();
			}
		}

35. Example

View license
[Test]
		public async Task TestDefaultValueAsync()
		{
			using (ISession s1 = OpenSession())
			{
				var cmd = s1.Connection.CreateCommand();
				cmd.CommandText =
					"insert into GetSetHelper(ID) values(1)";
				await (cmd.ExecuteNonQueryAsync());
			}

			try
			{
				// load the object and check default values
				using (ISession s2 = OpenSession())
				{
					GetSetHelper gs = (GetSetHelper) await (s2.LoadAsync(typeof(GetSetHelper), 1));

					Assert.AreEqual(new int(), gs.A);
					Assert.AreEqual(new TimeSpan(), gs.B);
					Assert.AreEqual(new bool(), gs.C);
					Assert.AreEqual(new DateTime(), gs.D);
					Assert.AreEqual(new short(), gs.E);
					Assert.AreEqual(new byte(), gs.F);
					Assert.AreEqual(new float(), gs.G);
					Assert.AreEqual(new double(), gs.H);
					Assert.AreEqual(new decimal(), gs.I);
					Assert.AreEqual(new GetSetHelper.TestEnum(), gs.L);
					Assert.IsNull(gs.M);
				}
			}
			finally
			{
				ExecuteStatement("delete from GetSetHelper");
			}
		}

36. Example

View license
private async Task ExecuteNonQueryAsync(string sql, List<SqlParameter> parameters = null)
        {
            using (var connection = new SqlConnection(_connectionString))
            using (var command = new SqlCommand(sql, connection))
            {
                await connection.OpenAsync();

                using (var tx = connection.BeginTransaction())
                {
                    command.Transaction = tx;

                    if (parameters?.Count > 0)
                    {
                        foreach (var p in parameters)
                        {
                            command.Parameters.Add(p);
                        }
                    }

                    await command.ExecuteNonQueryAsync();

                    tx.Commit();
                }
            }
        }

37. Example

View license
private static async Task WriteResultsToSql(
            string connectionString,
            Scenar/n ..... /n //View Source file for more details /n }

38. Example

View license
public static async Task<int> ExecuteNonQueryAsync(this DatabaseCommand databaseCommand, bool keepConnectionOpen = false)
        {
            int numberOfRowsAffected;

            try
            {
                Sequelocity.ConfigurationSettings.EventHandlers.InvokeDatabaseCommandPreExecuteEventHandlers(databaseCommand);

                await databaseCommand.DbCommand.OpenConnectionAsync();

                numberOfRowsAffected = await databaseCommand.DbCommand.ExecuteNonQueryAsync();

                Sequelocity.ConfigurationSettings.EventHandlers.InvokeDatabaseCommandPostExecuteEventHandlers(databaseCommand);
            }
            catch (Exception exception)
            {
                Sequelocity.ConfigurationSettings.EventHandlers.InvokeDatabaseCommandUnhandledExceptionEventHandlers(exception, databaseCommand);

                throw;
            }
            finally
            {
                if (keepConnectionOpen == false)
                {
                    databaseCommand.DbCommand.CloseAndDispose();

                    databaseCommand.DbCommand = null;
                }
            }

            return numberOfRowsAffected;
        }

39. Example

Project: DistributedLock
Source File: SqlHelpers.cs
View license
public static Task<int> ExecuteNonQueryAsync(this IDbCommand command, CancellationToken cancellationToken)
        {
            var dbCommand = command as DbCommand;
            if (dbCommand != null)
            {
                return cancellationToken.CanBeCanceled
                    ? InternalExecuteNonQueryAndPropagateCancellationAsync(dbCommand, cancellationToken)
                    : dbCommand.ExecuteNonQueryAsync();
            }

            // synchronous task pattern
            var taskBuilder = new TaskCompletionSource<int>();
            if (cancellationToken.IsCancellationRequested)
            {
                taskBuilder.SetCanceled();
                return taskBuilder.Task;
            }

            try
            {
                taskBuilder.SetResult(command.ExecuteNonQuery());
            }
            catch (Exception ex)
            {
                taskBuilder.SetException(ex);
            }

            return taskBuilder.Task;
        }

40. Example

View license
[Test]
		public async Task SecondLevelCacheWithHqlQueriesForItemWithCollectionsAsync()
		{
			using (ISession session = OpenSession())
			{
				IList list = await (session.CreateQuery("from Item i where i.Id > 2")
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);

				using (var cmd = session.Connection.CreateCommand())
				{
					cmd.CommandText = "DELETE FROM Item";
					await (cmd.ExecuteNonQueryAsync());
				}
			}

			using (ISession session = OpenSession())
			{
				//should bring from cache
				IList list = await (session.CreateQuery("from Item i where i.Id > 2")
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);
			}
		}

41. Example

View license
[Test]
		public async Task SecondLevelCacheWithHqlQueriesAsync()
		{
			using (ISession session = OpenSession())
			{
				IList list = await (session.CreateQuery("from AnotherItem i where i.Id > 2")
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);

				using (var cmd = session.Connection.CreateCommand())
				{
					cmd.CommandText = "DELETE FROM AnotherItem";
					await (cmd.ExecuteNonQueryAsync());
				}
			}

			using (ISession session = OpenSession())
			{
				//should bring from cache
				IList list = await (session.CreateQuery("from AnotherItem i where i.Id > 2")
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);
			}
		}

42. Example

Project: nhibernate-core
Source File: FooBarTest.cs
View license
[Test]
		public async Task RefreshTransientAsync()
		{
			ISession s = OpenSession();
			Foo foo = new Foo();
			await (s.SaveAsync(foo));
			await (s.FlushAsync());
			/* 
			Commented to have same behavior of H3.2 (test named FooBarTest.testRefresh())
			s.Close(); 
			s = OpenSession();
			btw using close and open a new session more than Transient the entity will be detached.
			*/
			var cmd = s.Connection.CreateCommand();
			cmd.CommandText = "update " + Dialect.QuoteForTableName("foos") + " set long_ = -3";
			await (cmd.ExecuteNonQueryAsync());
			await (s.RefreshAsync(foo));
			Assert.AreEqual(-3L, foo.Long);
			await (s.DeleteAsync(foo));
			await (s.FlushAsync());
			s.Close();
		}

43. Example

View license
public async Task<int> CreateAsync(DbConnection connection, T value, params object[] keyValues)
        {
            var sql = BuildSqlForCreate(value, keyValues);
            using (var command = _sqlProvider.CreateDbCommand(sql, connection))
            {
                if (_identityColumn != null)
                {
                    using (var reader = await command.ExecuteReaderAsync())
                    {
                        if (await reader.ReadAsync())
                        {
                            var columnValue = reader.GetValue(0);
                            _identityColumn.InstallFromDbValue(value, columnValue);
                            return 1;
                        }
                    }
                    return 0;
                }
                else
                {
                    return await command.ExecuteNonQueryAsync();
                }
            }
        }

44. Example

View license
[Test]
		public async Task BadGrammarAsync()
		{
			//ISQLExceptionConverter converter = Dialect.BuildSQLExceptionConverter();
			ISQLExceptionConverter converter = Sfi.Settings.SqlExceptionConverter;

			ISession session = OpenSession();
			var connection = session.Connection;

			// prepare/execute a query against a non-existent table
			DbCommand ps = null;
			try
			{
				ps = connection.CreateCommand();
				ps.CommandType = CommandType.Text;
				ps.CommandText = "SELECT user_id, user_name FROM tbl_no_there";
				await (ps.ExecuteNonQueryAsync());

				Assert.Fail("SQL compilation should have failed");
			}
			catch (Exception sqle)
			{
				Assert.AreEqual(typeof (SQLGrammarException),
				                converter.Convert(new AdoExceptionContextInfo {SqlException = sqle}).GetType(),
				                "Bad conversion [" + sqle.Message + "]");
			}
			finally
			{
				if (ps != null)
				{
					try
					{
						ps.Dispose();
					}
					catch (Exception)
					{
						// ignore...
					}
				}
			}

			session.Close();
		}

45. Example

Project: nhibernate-core
Source File: FooBarTest.cs
View license
[Test]
		public async Task CacheAsync()
		{
			NHibernate.DomainModel.Immutable im = new NHibernate.DomainModel.Immutable();

			using (ISession s = OpenSession())
			{
				await (s.SaveAsync(im));
				await (s.FlushAsync());
			}

			using (ISession s = OpenSession())
			{
				await (s.LoadAsync(im, im.Id));
			}

			using (ISession s = OpenSession())
			{
				await (s.LoadAsync(im, im.Id));

				NHibernate.DomainModel.Immutable imFromFind =
					(NHibernate.DomainModel.Immutable) (await (s.CreateQuery("from im in class Immutable where im = ?").SetEntity(0, im).ListAsync()))[0];
				NHibernate.DomainModel.Immutable imFromLoad = (NHibernate.DomainModel.Immutable) await (s.LoadAsync(typeof(NHibernate.DomainModel.Immutable), im.Id));

				Assert.IsTrue(im == imFromFind, "cached object identity from Find ");
				Assert.IsTrue(im == imFromLoad, "cached object identity from Load ");
			}

			// Clean up the immutable. Need to do this using direct SQL, since ISession
			// refuses to delete immutable objects.
			using (ISession s = OpenSession())
			{
				var connection = s.Connection;
				using (var command = connection.CreateCommand())
				{
					command.CommandText = "delete from immut";
					await (command.ExecuteNonQueryAsync());
				}
			}
		}

46. Example

Project: nhibernate-core
Source File: FooBarTest.cs
View license
[Test]
		public async Task RefreshAsync()
		{
			ISession s = OpenSession();
			Foo foo = new Foo();
			await (s.SaveAsync(foo));
			await (s.FlushAsync());

			var cmd = s.Connection.CreateCommand();
			cmd.CommandText = "update " + Dialect.QuoteForTableName("foos") + " set long_ = -3";
			await (cmd.ExecuteNonQueryAsync());

			await (s.RefreshAsync(foo));
			Assert.AreEqual((long) -3, foo.Long);
			Assert.AreEqual(LockMode.Read, s.GetCurrentLockMode(foo));
			await (s.RefreshAsync(foo, LockMode.Upgrade));
			Assert.AreEqual(LockMode.Upgrade, s.GetCurrentLockMode(foo));
			await (s.DeleteAsync(foo));
			await (s.FlushAsync());
			s.Close();
		}

47. Example

View license
[Test]
		public async Task SecondLevelCacheWithCriteriaQueriesAsync()
		{
			using (ISession session = OpenSession())
			{
				IList list = await (session.CreateCriteria(typeof(AnotherItem))
					.Add(Expression.Gt("Id", 2))
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);

				using (var cmd = session.Connection.CreateCommand())
				{
					cmd.CommandText = "DELETE FROM AnotherItem";
					await (cmd.ExecuteNonQueryAsync());
				}
			}

			using (ISession session = OpenSession())
			{
				//should bring from cache
				IList list = await (session.CreateCriteria(typeof(AnotherItem))
					.Add(Expression.Gt("Id", 2))
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);
			}
		}

48. Example

View license
[Test]
		public async Task SecondLevelCacheWithCriteriaQueriesForItemWithCollectionsAsync()
		{
			using (ISession session = OpenSession())
			{
				IList list = await (session.CreateCriteria(typeof(Item))
					.Add(Expression.Gt("Id", 2))
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);

				using (var cmd = session.Connection.CreateCommand())
				{
					cmd.CommandText = "DELETE FROM Item";
					await (cmd.ExecuteNonQueryAsync());
				}
			}

			using (ISession session = OpenSession())
			{
				//should bring from cache
				IList list = await (session.CreateCriteria(typeof(Item))
					.Add(Expression.Gt("Id", 2))
					.SetCacheable(true)
					.ListAsync());
				Assert.AreEqual(3, list.Count);
			}
		}

49. Example

View license
[HttpGet]
        public async Task<IActionResult> Index()
        {
            // [START exa/n ..... /n //View Source file for more details /n }

50. Example

Project: SqlServerTimeZoneSupport
Source File: Program.cs
View license
private static async Task WriteIntervalsAsync(IDictionary<string, int> zones, CurrentTzdbProvi/n ..... /n //View Source file for more details /n }