public async Task Update(TData entity) { var entityType = entity.GetType(); await dbQuery.ExecuteCommandAsync( $@"UPDATE [dbo].[{DbEntityHelper.GetDbTableName(entityType)}] SET {DbEntityHelper.GetUpdatePropertiesString(entity)} WHERE Id = @Id ", DbEntityHelper.GetSqlParameters(entity, excludeId : false).ToArray()); }
public Task <long> Add(TData entity) { var entityType = entity.GetType(); return(dbQuery.ExecuteInsertCommandAsync( $@"INSERT INTO [dbo].[{DbEntityHelper.GetDbTableName(entityType)}] ( {DbEntityHelper.GetPropertiesString(entityType)} ) VALUES ( {DbEntityHelper.GetSqlParametersString(entity)} )", DbEntityHelper.GetSqlParameters(entity).ToArray())); }