Exemplos de ISqlCommandDefinition.GetCommand em C# (CSharp)

Exemplo n.º 1

 public async Task <object> ExecuteScalarAsync(ISqlCommandDefinition command)
 {
     using (SqlCommand sqlCommand = command.GetCommand())
     {
         sqlCommand.Connection = Connection;
         return(await sqlCommand.ExecuteScalarAsync());
     }
 }

Exemplo n.º 2

 public object ExecuteScalar(ISqlCommandDefinition command)
 {
     using (SqlCommand sqlCommand = command.GetCommand())
     {
         sqlCommand.Connection = Connection;
         return(sqlCommand.ExecuteScalar());
     }
 }

Exemplo n.º 3

 public int ExecuteNonQuery(ISqlCommandDefinition command)
 {
     using (SqlCommand sqlCommand = command.GetCommand())
     {
         sqlCommand.Connection = Connection;
         return(sqlCommand.ExecuteNonQuery());
     }
 }

Exemplo n.º 4

 public async Task <int> ExecuteNonQueryAsync(ISqlCommandDefinition command)
 {
     using (SqlCommand sqlCommand = command.GetCommand())
     {
         sqlCommand.Connection = Connection;
         OpenConnection();
         return(await sqlCommand.ExecuteNonQueryAsync());
     }
 }