Componyx.Data.DAL

Inheritance

Inherited Members

Properties

Name	Type	Description
AutoDetectForeignKeys	System.Boolean	Gets or sets a value indicating whether property names that consist of parent name and key are being treated as foreign keys.
ColumnAliasMapping	System.Collections.Generic.Dictionary`2	Gets or sets the dictionary where the key represents the (hierachical) property name and the value represents the column alias name.
ColumnLookupTableNameValidation	System.Boolean	Gets or sets a value indicating whether the table name of the class type is validated when a column lookup is performed in the schema table.
Connection	System.Data.Common.DbConnection	Gets or sets the current Connection.
DefaultProviderName	System.String	Gets or sets the default database provider name used when opening a connection with the Open method that does not specify a provider name.
Factory	System.Data.Common.DbProviderFactory	Gets the database provider Factory.
IgnoreMissingColumns	System.Boolean	Gets or sets a value indicating whether an exception is thrown or if the property value is set to null when a column is missing in the query result.
IgnoreTypes	System.Collections.Generic.HashSet`1	Gets or sets relationship types that should be ignored when retrieving data.
IsolationLevel	System.Data.IsolationLevel	Gets or sets the isolation level of the transaction.
LoadOneToMany	System.Boolean	Gets or sets a value indicating if one-to-many relations of the target type should be loaded.
LoadOneToOne	System.Boolean	Gets or sets a value indicating if one-to-one relations of the target type should be loaded.
NameComparison	System.StringComparison	Gets or sets a value indicating which string comparison option is used for comparing column and table names.
NamedParameters	System.Nullable`1	Gets or sets a value indicating whether named parameters are supported by the database provider.
PageSize	System.Nullable`1	Gets or sets the page size used in a paging enabled query.
ParameterMarker	System.Nullable`1	Gets or sets the parameter prefix.
SqlColumnOrdinal	Componyx.Data.SqlColumnOrdinalOption	Gets or sets the option used for retrieving columns based upon column ordinals. Default value: ZeroBased.
SqlDelimitedIdentifier	Componyx.Data.SqlDelimitedIdentifierOption	Gets or sets the option used for delimited identifiers. Default value: DoubleQuotes.
SqlLastIdCommand	System.String	Gets or sets the command to retrieve the last inserted id within the current scope. This command must be set to be able to refresh inserted entities with an auto increment key. Default value: SELECT SCOPE_IDENTITY().
SqlResultLimiter	Componyx.Data.SqlLimitOption	Gets or sets the option used for limiting the result set.
SqlTopLimiter	Componyx.Data.SqlTopLimitOption	Gets or sets the option used for selecting top results.
TableIndexMapping	System.Collections.Generic.Dictionary`2	Gets or sets the dictionary where the key represents the (hierachical) property name and the value represents the table index in the table schema. This is useful when the resultset contains multiple column sets of the same table (through joins).
TotalItemCount	System.Nullable`1	Gets the total item count of the last query when paging parameters where specified.
UseDefaultValuesInsertCommand	System.Boolean	Gets or sets a value indicating if 'DEFAULT VALUES' is used in the SQL INSERT command when there are no columns to insert. This command must be set to be able to save a new empty object without any column values set and no columns supporting a DBNULL-value insert. If set to false, this would result in an empty column and values list in the generated INSERT command (Most DB-providers do not support this. Set to false when using MySQL). Default value: true

Methods

#ctor ()
Initializes a new instance of the DAL class and opens the database connection.

#ctor ( connection, providerName, isolationLevel, parameterMarker, namedParameters )

Initializes a new instance of the DAL class and opens the database connection.

Name	Type	Description
connection	System.Data.Common.DbConnection	An instance of a database connection.
providerName	System.String	The database provider name. e.g. System.Data.SqlClient (default).
isolationLevel	System.Data.IsolationLevel	The isolation level of the transaction.
parameterMarker	System.Nullable{System.Char}	The character used to designate parameters. If omitted an attempt is made to get the parameter marker from the database schema. Defaults to @ when it is not found in the schema.
namedParameters	System.Nullable{System.Boolean}	A value indicating whether named parameters are supported by the database provider. If ommited an attempt is made to define named parameter support from the database schema.

#ctor ( connection, providerName, isolationLevel, parameterMarker, namedParameters )

Initializes a new instance of the DAL class and opens the database connection.

Name	Type	Description
connection	System.String	The Connection string.
providerName	System.String	The database provider name. e.g. System.Data.SqlClient (default).
isolationLevel	System.Data.IsolationLevel	The isolation level of the transaction.
parameterMarker	System.Nullable{System.Char}	The character used to designate parameters. If omitted an attempt is made to get the parameter marker from the database schema. Defaults to @ when it is not found in the schema.
namedParameters	System.Nullable{System.Boolean}	A value indicating whether named parameters are supported by the database provider. If ommited an attempt is made to define named parameter support from the database schema.

AddCatalog ( types, catalogName, schemaName, serverName )
Adds the catalog for the specified types.
Name Type Description
types System.Collections.Generic.List{System.Type} -
catalogName System.String -
schemaName System.String -
serverName System.String -
AddCatalog ( type, catalogName, schemaName, serverName )
Adds the catalog for the specified type.
Name Type Description
type System.Type -
catalogName System.String -
schemaName System.String -
serverName System.String -
AddKeyDataRow ( rows, columnName, keyRows )
Adds the key data row with the specified column name to the list of key rows.
Name Type Description
rows System.Collections.Generic.List{System.Data.DataRow} -
columnName System.String -
keyRows System.Collections.Generic.List{System.Data.DataRow} -
AddParameterMarker ( name )
Adds the parameter marker to the specified parameter name.
Name Type Description
name System.String -
Returns
The parameter name with marker.

AddToCollection ( reader, type, parent, treeName, tableName, columnName, rlTypes, list, listSet )

Adds the object to the specified list.

Name	Type	Description
reader	System.Data.Common.DbDataReader	-
type	System.Type	-
parent	Componyx.Data.DAL.Relation	-
treeName	System.String	-
tableName	System.String	-
columnName	System.String	-
rlTypes	System.Collections.Generic.Dictionary{System.String,System.String}	-
list	System.Collections.IList	-
listSet	System.Collections.Generic.HashSet{System.Object}	-

BeginTransaction ()
Begins a transaction and keeps track of new commands within the current transaction.
ClearCatalogs ()
Removes all catalogs.
CloseReader ()
Closes the global data reader.
CommitChanges ( obj, deep, refreshModel, parentType, parentKeyInfoList )
Commit changes.
Name Type Description
obj System.Object -
deep System.Boolean -
refreshModel System.Boolean -
parentType System.Boolean -
parentKeyInfoList System.Type -

CommitChangesAsync ( obj, deep, refreshModel, existenceCheck, parentType, parentKeyInfoList )

Commits the changes.

Name	Type	Description
obj	System.Object	-
deep	System.Boolean	-
refreshModel	System.Boolean	-
existenceCheck	System.Boolean	-
parentType	System.Type	-
parentKeyInfoList	System.Collections.Generic.List{Componyx.Data.DAL.KeyInfo}	-

Returns

CommitDelete ( obj, deep )
Deletes the object.
Name Type Description
obj System.Object -
deep System.Boolean -
CommitDeleteAsync ( obj, deep )
Deletes the object.
Name Type Description
obj System.Object -
deep System.Boolean -
CommitTransaction ()
Keeps track of the commands within the current transaction and commits the transaction after the last command.

CreateClass ( reader, type, parent, treeName, rlTypes, list, listSet )

Creates a new class instance of the specified type and fills it from the data reader.

Name	Type	Description
reader	System.Data.Common.DbDataReader	-
type	System.Type	-
parent	Componyx.Data.DAL.Relation	-
treeName	System.String	-
rlTypes	System.Collections.Generic.Dictionary{System.String,System.String}	-
list	System.Collections.IList	-
listSet	System.Collections.Generic.HashSet{System.Object}	-

Returns

CreateColumns<T> ( tableData, obj, deep, parentType, parentKeyInfoList, keyInfoList, childs )

Creates insert/update columns.

Name	Type	Description
tableData	Componyx.Data.DAL.TableData	-
obj	<T>	-
deep	System.Boolean	-
parentType	System.Type	-
parentKeyInfoList	System.Collections.Generic.List{Componyx.Data.DAL.KeyInfo}	-
keyInfoList	System.Collections.Generic.List{Componyx.Data.DAL.KeyInfo}	-
childs	System.Collections.Generic.List{System.Object}	-

Returns

CreateCommand ()
Creates a new command for the current database provider.
Returns
The command object instance
CreateCommand ( text, parameters, timeout, type )
Creates a new command for the current database provider.
Name Type Description
text System.String -
parameters System.Collections.Generic.List{System.Data.IDataParameter} -
timeout System.Nullable{System.Int32} -
type System.Nullable{System.Data.CommandType} -
Returns
The command object instance
CreateDeleteCommand ( obj, type, tableData, deep, childs )
Creates the delete command.
Name Type Description
obj System.Object -
type System.Type -
tableData Componyx.Data.DAL.TableData -
deep System.Boolean -
childs System.Collections.Generic.List{System.Object} -
Returns
CreateExistsCommand ( tableData, cmd, columns )
Creates the exists command.
Name Type Description
tableData Componyx.Data.DAL.TableData -
cmd System.Data.Common.DbCommand -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
Returns
CreateInsertCommand ( type, tableData, columns )
Creates the insert command.
Name Type Description
type System.Type -
tableData Componyx.Data.DAL.TableData -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
Returns

CreateJoins ( type, parent, loadOneToMany, loadOneToOne, columns, tables, treeName, tableAliasMapping, rlTypes, rlTableData, rlKeyInfoList, rlTableAlias, oneToManyRelation, occurredTypes )

Creates the table joins for the load method.

Name	Type	Description
type	System.Type	-
parent	Componyx.Data.DAL.Relation	-
loadOneToMany	System.Boolean	-
loadOneToOne	System.Boolean	-
columns	System.Collections.Generic.List{System.String}	-
tables	System.Collections.Generic.List{System.String}	-
treeName	System.String	-
tableAliasMapping	System.Collections.Generic.Dictionary{System.String,System.String}	-
rlTypes	System.Collections.Generic.HashSet{System.String}	-
rlTableData	Componyx.Data.DAL.TableData	-
rlKeyInfoList	System.Collections.Generic.List{Componyx.Data.DAL.KeyInfo}	-
rlTableAlias	System.Int32	-
oneToManyRelation	System.Boolean	-
occurredTypes	System.Collections.Generic.Dictionary{System.String,System.Int32}	-

CreateParameter ( cmd, name, value, direction )
Creates a new parameter for the current database provider.
Name Type Description
cmd System.Data.Common.DbCommand -
name System.String -
value System.Object -
direction System.Nullable{System.Data.ParameterDirection} -
Returns
The parameter name.
CreateParameter ( name, value, direction, type )
Creates a new parameter for the current database provider.
Name Type Description
name System.String -
value System.Object -
direction System.Nullable{System.Data.ParameterDirection} -
type System.Nullable{System.Data.DbType} -
Returns
The parameter object instance
CreateSelectCommand ( tableData, columns, where, id )
Creates the select command.
Name Type Description
tableData Componyx.Data.DAL.TableData -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
where System.String -
id System.Nullable{System.Int64} -
Returns
CreateUpdateCommand ( type, tableData, columns, where )
Creates the update command.
Name Type Description
type System.Type -
tableData Componyx.Data.DAL.TableData -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
where System.String -
Returns
DefaultSchemaFilter ( row, type, tableName )
Filters the schema rows on server, catalog and table name.
Name Type Description
row System.Data.DataRow -
type System.Type -
tableName System.String -
Returns

Delete ( obj, deep, globalTransaction )

Deletes the object's corresponding record from the database table.

Name	Type	Description
obj	System.Object	Object to save.
deep	System.Boolean	Delete child objects.
globalTransaction	System.Boolean	Defines if a global transaction is used to remove the object and it's child objects.

DeleteAsync ( obj, deep, globalTransaction )

Deletes the object's corresponding record from the database table.

Name	Type	Description
obj	System.Object	Object to save.
deep	System.Boolean	Delete child objects.
globalTransaction	System.Boolean	Defines if a global transaction is used to remove the object and it's child objects.

DeleteSet<T> ( list, deep, globalTransaction )

Deletes the object's corresponding records from the database table.

Name	Type	Description
list	System.Collections.IEnumerable	List of objects to save.
deep	System.Boolean	Delete child objects.
globalTransaction	System.Boolean	Defines if a global transaction is used to remove the object and it's child objects.

DeleteSetAsync<T> ( list, deep, globalTransaction )

Deletes the object's corresponding records in the database table.

Name	Type	Description
list	System.Collections.IEnumerable	List of objects to save.
deep	System.Boolean	Delete child objects.
globalTransaction	System.Boolean	Defines if a global transaction is used to store and refresh the object and it's child objects.

Dispose ()
Disposes the dal.
Escape ( name )
Name Type Description
name System.String -
Returns
FindFKColumnName ( properties, type, propertyName, columnName, treeName )
Finds the foreignkey column in the property list of the data relation.
Name Type Description
properties System.Collections.Generic.List{System.Reflection.PropertyInfo} -
type System.Type -
propertyName System.String -
columnName System.String -
treeName System.String -
Returns
The foreignkey column name.
GetColumnName ( property )
Gets the column name for the specified property.
Name Type Description
property System.Reflection.PropertyInfo -
Returns
GetFKAttributes ( property )
Gets a list of ForeignKey attributes for the specified property.
Name Type Description
property System.Reflection.PropertyInfo -
Returns
GetKeyFields ( type, useColumnAttribute )
Gets the key fields for the specified type.
Name Type Description
type System.Type -
useColumnAttribute System.Boolean -
Returns
GetOrdinal ( treeName, tableName, columnName, isClass )
Retrieves the column ordinal.
Name Type Description
treeName System.String -
tableName System.String -
columnName System.String -
isClass System.Boolean -
Returns
GetParameterMarker ()
Returns
GetParameterNameMaxLength ()
Returns
GetPropertyName<T> ( propertyExpression )
Gets the name of an instance property from a property access lambda.
Name Type Description
propertyExpression System.Linq.Expressions.Expression{System.Func{<T>}} Lambda expression in the form: '() => Class.Property'.
Returns
The name of the property.
GetPropertyNames ( propertyExpressions )
Gets the name of an instance property from a property access lambda.
Name Type Description
propertyExpressions System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} A list of Lambda expression in the form: '() => Class.Property'.
Returns
The name of the property.
GetPropInfo ( property )
Gets (and caches) property information.
Name Type Description
property System.Reflection.PropertyInfo -
Returns
GetSchemaKeyData ( reader, type, treeName )
Gets unique key data for the specified type.
Name Type Description
reader System.Data.Common.DbDataReader -
type System.Type -
treeName System.String -
Returns
GetSchemaTable ( tableName )
Gets the column metadata for the specified table.
Name Type Description
tableName System.String -
Returns
A DataTable that describes the column metadata of the specified table.
GetSchemaTableData ( type, typeSchema, treeName )
Gets schema table data for the specified type.
Name Type Description
type System.Type -
typeSchema System.Boolean -
treeName System.String -
Returns
GetTableName ( type )
Gets the table name for the specified type.
Name Type Description
type System.Type -
Returns
GetValue ( reader, type, parentType, treeName, tableName, columnName, isClass )
Gets the value from the reader.
Name Type Description
reader System.Data.Common.DbDataReader -
type System.Type -
parentType System.Type -
treeName System.String -
tableName System.String -
columnName System.String -
isClass System.Boolean -
Returns
HandleError ()
HasIdentity ( tableData )
Checks if the table has an identity column.
Name Type Description
tableData Componyx.Data.DAL.TableData -
Returns
HasType ( types, type )
Checks if the type is in the specified types set.
Name Type Description
types System.Collections.Generic.HashSet{System.Type} -
type System.Type -
Returns
IncludeCatalog ( type, tableName )
Prefixes the catalog name to the table name if there is a catalog mapped for the specified type.
Name Type Description
type System.Type -
tableName System.String -
Returns
Init ( isolationLevel, parameterMarker, namedParameters )
Initializes the DAL.
Name Type Description
isolationLevel System.Data.IsolationLevel -
parameterMarker System.Nullable{System.Char} -
namedParameters System.Nullable{System.Boolean} -
InitFactory ( providerName, connection )
Init DB Factory.
Name Type Description
providerName System.String -
connection System.String -
InitQuery ()
Initializes a new query.
Insert ( obj, columns, where, refreshModel )
Inserts the object.
Name Type Description
obj System.Object -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
where System.String -
refreshModel System.Boolean -
InsertAsync ( obj, columns, where, refreshModel )
Inserts the object.
Name Type Description
obj System.Object -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
where System.String -
refreshModel System.Boolean -
IsMapped ( property )
Checks if the property is mapped.
Name Type Description
property System.Reflection.PropertyInfo -
Returns
IsMapped ( type )
Checks if the type is mapped.
Name Type Description
type System.Type -
Returns
A value indicating if the type is mapped.
IsNumeric ( type )
Checks if property type is numeric
Name Type Description
type System.Type -
Returns
IsReadOnly ( property )
Checks if the property is DB read-only.
Name Type Description
property System.Reflection.PropertyInfo -
Returns
LimitResult ( cmd, skip, take )
Limit result for flat query.
Name Type Description
cmd System.Data.Common.DbCommand -
skip System.Int32 -
take System.Int32 -
Returns
LimitResult<T> ( cmd, skip, take )
Limit result for query of known type.
Name Type Description
cmd System.Data.Common.DbCommand -
skip System.Int32 -
take System.Int32 -
Returns

Load<T> ( obj, loadOneToMany, loadOneToOne, sortOrder )

Loads and fills the object with the retrieved data from the corresponding database record.

Name	Type	Description
obj	<T>	-
loadOneToMany	System.Boolean	A value indicating if one-to-many relations of the target type should be loaded.
loadOneToOne	System.Boolean	A value indicating if one-to-one relations of the target type should be loaded.
sortOrder	System.Collections.Generic.List{System.Collections.Generic.KeyValuePair{System.String,System.Boolean}}	The sort order by specifying a KeyValuePair with the property name as key and a boolean value to indicate if the sort order is ascending(false) or descending(true).

Returns

The loaded object.

LoadAsync<T> ( obj, loadOneToMany, loadOneToOne, sortOrder )

Loads and fills the object with the retrieved data from the corresponding database record.

Name	Type	Description
obj	<T>	-
loadOneToMany	System.Boolean	A value indicating if one-to-many relations of the target type should be loaded.
loadOneToOne	System.Boolean	A value indicating if one-to-one relations of the target type should be loaded.
sortOrder	System.Collections.Generic.List{System.Collections.Generic.KeyValuePair{System.String,System.Boolean}}	The sort order by specifying a KeyValuePair with the property name as key and a boolean value to indicate if the sort order is ascending(false) or descending(true).

Returns

The loaded object.

NonQuery ( cmd )
Executes a query and returns the number of rows affected.
Name Type Description
cmd System.Data.Common.DbCommand -
Returns
NonQueryAsync ( cmd )
Executes a query and returns the number of rows affected.
Name Type Description
cmd System.Data.Common.DbCommand -
Returns

OpenAsync ( connection, providerName, isolationLevel, parameterMarker, namedParameters )

Opens the database connection async.

Name	Type	Description
connection	System.Data.Common.DbConnection	An instance of a database connection.
providerName	System.String	The database provider name. e.g. System.Data.SqlClient (default).
isolationLevel	System.Data.IsolationLevel	The isolation level of the transaction.
parameterMarker	System.Nullable{System.Char}	The character used to designate parameters. If omitted an attempt is made to get the parameter marker from the database schema. Defaults to @ when it is not found in the schema.
namedParameters	System.Nullable{System.Boolean}	A value indicating whether named parameters are supported by the database provider. If ommited an attempt is made to define named parameter support from the database schema.

OpenAsync ( connection, providerName, isolationLevel, parameterMarker, namedParameters )

Opens the database connection async.

Name	Type	Description
connection	System.String	The Connection string.
providerName	System.String	The database provider name. e.g. System.Data.SqlClient (default).
isolationLevel	System.Data.IsolationLevel	The isolation level of the transaction.
parameterMarker	System.Nullable{System.Char}	The character used to designate parameters. If omitted an attempt is made to get the parameter marker from the database schema. Defaults to @ when it is not found in the schema.
namedParameters	System.Nullable{System.Boolean}	A value indicating whether named parameters are supported by the database provider. If ommited an attempt is made to define named parameter support from the database schema.

PagedResult ( cmd, pageIndex )
Limit query result by page index for flat query.
Name Type Description
cmd System.Data.Common.DbCommand -
pageIndex System.Nullable{System.Int32} -
Returns
PagedResult<T> ( cmd, pageIndex )
Limit query result by page index for query of known type.
Name Type Description
cmd System.Data.Common.DbCommand -
pageIndex System.Nullable{System.Int32} -
Returns
Query ( type, cmd )
Executes the query command.
Name Type Description
type System.Type -
cmd System.Data.Common.DbCommand -
Returns

Query<T> ( loadOneToMany, loadOneToOne )

Creates a new instance of the FluentQuery class to build a query with fluent syntax.

Name	Type	Description
loadOneToMany	System.Boolean	A value indicating if one-to-many relations of the target type should be loaded.
loadOneToOne	System.Boolean	A value indicating if one-to-one relations of the target type should be loaded.

Returns

A FluentQueryT class.

Query<T> ( cmd, pageIndex )
Executes a query and returns the result as a list of T.
Name Type Description
cmd System.Data.Common.DbCommand The command object.
pageIndex System.Nullable{System.Int32} The page index.
Returns
A List of T.
QueryAsDataSet ( cmd, pageIndex )
Executes a query and returns the result as a dataset.
Name Type Description
cmd System.Data.Common.DbCommand Command object.
pageIndex System.Nullable{System.Int32} The page index.
Returns
QueryAsDataSetAsync ( cmd, pageIndex )
Executes a query and returns the result as a dataset.
Name Type Description
cmd System.Data.Common.DbCommand Command object.
pageIndex System.Nullable{System.Int32} The page index.
Returns
QueryAsReader ( cmd, pageIndex )
Executes a query and returns the result as DbDataReader.
Name Type Description
cmd System.Data.Common.DbCommand The command object.
pageIndex System.Nullable{System.Int32} The page index.
Returns
An DbDataReader object.
QueryAsReaderAsync ( cmd, pageIndex )
Executes a query and returns the result as DbDataReader.
Name Type Description
cmd System.Data.Common.DbCommand The command object.
pageIndex System.Nullable{System.Int32} The page index.
Returns
An DbDataReader object.
QueryAsync ( type, cmd )
Quer
Name Type Description
type System.Type -
cmd System.Data.Common.DbCommand -
Returns
QueryAsync<T> ( cmd, pageIndex )
Executes a query and returns the result as a list of T.
Name Type Description
cmd System.Data.Common.DbCommand The command object.
pageIndex System.Nullable{System.Int32} The page index.
Returns
A List of T.
RefreshModel ( original, updated )
Refreshes the data model.
Name Type Description
original System.Object -
updated System.Object -
RemoveCatalog ( types )
Removes the catalog for the specified types.
Name Type Description
types System.Collections.Generic.List{System.Type} -
RemoveCatalog ( type )
Removes the catalog for the specified type.
Name Type Description
type System.Type -
Save ( ds, selectCmd )
Saves the dataset's corresponding records in the database.
Name Type Description
ds System.Data.DataSet -
selectCmd System.Data.Common.DbCommand -

Save ( obj, deep, refreshModel, globalTransaction )

Saves the object's corresponding record in the database table.

Name	Type	Description
obj	System.Object	Object to save.
deep	System.Boolean	Save child objects.
refreshModel	System.Boolean	Defines if the object model is refreshed after saving.
globalTransaction	System.Boolean	Defines if a global transaction is used to store and refresh the object and it's child objects.

SaveAsync<T> ( obj, deep, refreshModel, globalTransaction )

Saves the object's corresponding record in the database table, inserting new records and updating existing ones.

Name	Type	Description
obj	<T>	Object to save.
deep	System.Boolean	Save child objects.
refreshModel	System.Boolean	Defines if the object model is refreshed after saving.
globalTransaction	System.Boolean	Defines if a global transaction is used to store and refresh the object and it's child objects.

SaveBatchAsync<T> ( items, globalTransaction )
Inserts a batch of new records into the database asynchronously without checking for existing records. Faster than SaveSetAsync<T> for scenarios where records are guaranteed to be new, such as after a table truncate. Does not support storing child objects or refreshing models after saving.
Name Type Description
items System.Collections.IEnumerable List of new objects to insert.
globalTransaction System.Boolean Defines if a global transaction is used for all inserts.

SaveSet<T> ( items, deep, refreshModel, globalTransaction )

Saves a collection of objects to the database asynchronously, inserting new records and updating existing ones.

Name	Type	Description
items	System.Collections.IEnumerable	List of objects to save.
deep	System.Boolean	Save child objects.
refreshModel	System.Boolean	Defines if the object model is refreshed after saving.
globalTransaction	System.Boolean	Defines if a global transaction is used to store and refresh the object and it's child objects.

SaveSetAsync<T> ( items, deep, refreshModel, globalTransaction )

Saves a collection of objects to the database asynchronously, inserting new records and updating existing ones.

Name	Type	Description
items	System.Collections.IEnumerable	List of objects to save.
deep	System.Boolean	Whether to also save child objects.
refreshModel	System.Boolean	Whether to refresh the object model after saving, updating properties such as generated identity values.
globalTransaction	System.Boolean	Defines if a global transaction is used for all saves.

Scalar<T> ( cmd )
Executes a query and returns the result as T.
Name Type Description
cmd System.Data.Common.DbCommand Command object.
Returns
ScalarAsync<T> ( cmd )
Executes a query and returns the result as T.
Name Type Description
cmd System.Data.Common.DbCommand Command object.
Returns
SplitOrderBy ( orderByClause )
Handles splitting of the ORDER BY clause, avoiding commas inside function calls like JSON_VALUE(column, property).
Name Type Description
orderByClause System.String -
Returns
StoreSchemaColumns ( schema )
Stores the columns from the schema table for quick access.
Name Type Description
schema System.Data.DataTable -
TableInSchema ( type )
Checks if the table is part of the current schema.
Name Type Description
type System.Type -
Returns
Update ( obj, columns, where, refreshModel )
Updates the object.
Name Type Description
obj System.Object -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
where System.String -
refreshModel System.Boolean -
UpdateAsync ( obj, columns, where, refreshModel )
Updates the object.
Name Type Description
obj System.Object -
columns System.Collections.Generic.Dictionary{System.String,System.Data.IDataParameter} -
where System.String -
refreshModel System.Boolean -
Returns
UpdateKeyValues ( obj, keyInfoList, properties )
Update key values after insert because the table could have an auto increment identity
Name Type Description
obj System.Object -
keyInfoList System.Collections.Generic.List{Componyx.Data.DAL.KeyInfo} -
properties System.Collections.Generic.List{System.Reflection.PropertyInfo} -

Where<T> ( propertyExpression, openGroups, loadOneToMany, loadOneToOne )

Creates a new instance of the FluentQuery class to build a query with fluent syntax and initializes the where clause.

Name	Type	Description
propertyExpression	System.Linq.Expressions.Expression{System.Func{System.Object}}	Lambda expression of the form: '() => Class.Property'.
openGroups	System.Int32	Count of groups to open
loadOneToMany	System.Boolean	A value indicating if one-to-many relations of the target type should be loaded.
loadOneToOne	System.Boolean	A value indicating if one-to-one relations of the target type should be loaded.

Returns

A FluentQueryT class.

Where<T> ( propertyName, openGroups, loadOneToMany, loadOneToOne )

Creates a new instance of the FluentQuery class to build a query with fluent syntax and initializes the where clause.

Name	Type	Description
propertyName	System.String	The property name of the root class, dot separated tree name for parent/child classes or empty if a filter is not required.
openGroups	System.Int32	Count of groups to open
loadOneToMany	System.Boolean	A value indicating if one-to-many relations of the target type should be loaded.
loadOneToOne	System.Boolean	A value indicating if one-to-one relations of the target type should be loaded.