private async Task <object> InsertAsyncImp <T>(PocoData pocoData, string tableName, string primaryKeyName, bool autoIncrement, T poco, bool sync) { if (!OnInsertingInternal(new InsertContext(poco, tableName, autoIncrement, primaryKeyName))) { return(0); } try { OpenSharedConnectionInternal(); var preparedInsert = InsertStatements.PrepareInsertSql(this, pocoData, tableName, primaryKeyName, autoIncrement, poco); using (var cmd = CreateCommand(_sharedConnection, preparedInsert.Sql, preparedInsert.Rawvalues.ToArray())) { // Assign the Version column InsertStatements.AssignVersion(poco, preparedInsert); object id; if (!autoIncrement) { _ = sync ? ExecuteNonQueryHelper(cmd) : await ExecuteNonQueryHelperAsync(cmd).ConfigureAwait(false); id = InsertStatements.AssignNonIncrementPrimaryKey(primaryKeyName, poco, preparedInsert); } else { id = sync ? _dbType.ExecuteInsert(this, cmd, primaryKeyName, preparedInsert.PocoData.TableInfo.UseOutputClause, poco, preparedInsert.Rawvalues.ToArray()) : await _dbType.ExecuteInsertAsync(this, cmd, primaryKeyName, preparedInsert.PocoData.TableInfo.UseOutputClause, poco, preparedInsert.Rawvalues.ToArray()).ConfigureAwait(false); InsertStatements.AssignPrimaryKey(primaryKeyName, poco, id, preparedInsert); } return(id); } } catch (Exception x) { OnExceptionInternal(x); throw; } finally { CloseSharedConnectionInternal(); } }
/// <summary> /// Performs an SQL Insert /// </summary> /// <param name="tableName">The name of the table to insert into</param> /// <param name="primaryKeyName">The name of the primary key column of the table</param> /// <param name="autoIncrement">True if the primary key is automatically allocated by the DB</param> /// <param name="poco">The POCO object that specifies the column values to be inserted</param> /// <returns>The auto allocated primary key of the new record, or null for non-auto-increment tables</returns> /// <remarks>Inserts a poco into a table. If the poco has a property with the same name /// as the primary key the id of the new record is assigned to it. Either way, /// the new id is returned.</remarks> public virtual async Task <object> InsertAsync <T>(string tableName, string primaryKeyName, bool autoIncrement, T poco) { if (!OnInserting(new InsertContext(poco, tableName, autoIncrement, primaryKeyName))) { return(0); } try { OpenSharedConnectionInternal(); var preparedInsert = InsertStatements.PrepareInsertSql(this, tableName, primaryKeyName, autoIncrement, poco); using (var cmd = CreateCommand(_sharedConnection, preparedInsert.Sql, preparedInsert.Rawvalues.ToArray())) { // Assign the Version column InsertStatements.AssignVersion(poco, preparedInsert); object id; if (!autoIncrement) { await _dbType.ExecuteNonQueryAsync(this, cmd).ConfigureAwait(false); id = InsertStatements.AssignNonIncrementPrimaryKey(primaryKeyName, poco, preparedInsert); } else { id = await _dbType.ExecuteInsertAsync(this, cmd, primaryKeyName, poco, preparedInsert.Rawvalues.ToArray()).ConfigureAwait(false); InsertStatements.AssignPrimaryKey(primaryKeyName, poco, id, preparedInsert); } return(id); } } catch (Exception x) { OnException(x); throw; } finally { CloseSharedConnectionInternal(); } }