/// <summary> /// Performs CRUD execution of queries that do not return result set. Override to do custom Query interpretation /// </summary> protected internal async virtual Task <int> DoExecuteWithoutFetchAsync(SqlConnection cnn, SqlTransaction transaction, Query[] queries) { if (queries == null) { return(0); } var affected = 0; foreach (var query in queries) { var handler = QueryResolver.Resolve(query); try { affected += await handler.ExecuteWithoutFetchAsync(new MsSqlCRUDQueryExecutionContext(this, cnn, transaction), query); } catch (Exception error) { throw new MsSqlDataAccessException( StringConsts.EXECUTE_WITHOUT_FETCH_ERROR + error.ToMessageWithType(), error, KeyViolationKind.Unspecified, CRUDGenerator.KeyViolationName(error)); } } return(affected); }
/// <summary> /// Performs CRUD load. Override to do custom Query interpretation /// </summary> protected internal async virtual Task <List <RowsetBase> > DoLoadAsync(SqlConnection cnn, SqlTransaction transaction, Query[] queries, bool oneDoc = false) { var result = new List <RowsetBase>(); if (queries == null) { return(result); } foreach (var query in queries) { var handler = QueryResolver.Resolve(query); try { var rowset = await handler.ExecuteAsync(new MsSqlCRUDQueryExecutionContext(this, cnn, transaction), query, oneDoc); result.Add(rowset); } catch (Exception error) { throw new MsSqlDataAccessException( StringConsts.LOAD_ERROR + error.ToMessageWithType(), error, KeyViolationKind.Unspecified, CRUDGenerator.KeyViolationName(error)); } } return(result); }
/// <summary> /// Performs CRUD load. Override to do custom Query interpretation /// </summary> protected internal async virtual Task <Cursor> DoOpenCursorAsync(SqlConnection cnn, SqlTransaction transaction, Query query) { var context = new MsSqlCRUDQueryExecutionContext(this, cnn, transaction); var handler = QueryResolver.Resolve(query); try { return(await handler.OpenCursorAsync(context, query).ConfigureAwait(false)); } catch (Exception error) { throw new MsSqlDataAccessException( StringConsts.OPEN_CURSOR_ERROR + error.ToMessageWithType(), error, KeyViolationKind.Unspecified, CRUDGenerator.KeyViolationName(error)); } }
/// <summary> /// Performs CRUD load without fetching data only returning schema. Override to do custom Query interpretation /// </summary> protected internal async virtual Task <Schema> DoGetSchemaAsync(SqlConnection cnn, SqlTransaction transaction, Query query) { if (query == null) { return(null); } var handler = QueryResolver.Resolve(query); try { return(await handler.GetSchemaAsync(new MsSqlCRUDQueryExecutionContext(this, cnn, transaction), query).ConfigureAwait(false)); } catch (Exception error) { throw new MsSqlDataAccessException( StringConsts.GET_SCHEMA_ERROR + error.ToMessageWithType(), error, KeyViolationKind.Unspecified, CRUDGenerator.KeyViolationName(error)); } }