DbLinkExtensions
Namespace: TagBites.DB
Assembly: TagBites.DB.dll
Product: TagBites.DB v. 1.0.37
public static class DbLinkExtensionsInheritance: object → DbLinkExtensions
Methods
Section titled “Methods”BatchExecute(IDbLink, string, object[])
Section titled “BatchExecute(IDbLink, string, object[])”public static QueryResult[] BatchExecute(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”DelayedBatchExecute(IDbLink, string, object[])
Section titled “DelayedBatchExecute(IDbLink, string, object[])”public static DelayedBatchQueryResult DelayedBatchExecute(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Delete<T>(IDbLink, T)
Section titled “Delete<T>(IDbLink, T)”public static int Delete(this IDbLink link, this T entity)Parameters
Section titled “Parameters”linkIDbLinkentityT
Returns
Section titled “Returns”Delete<T>(IDbLink, IEnumerable<T>)
Section titled “Delete<T>(IDbLink, IEnumerable<T>)”public static int Delete(this IDbLink link, this IEnumerable<T> entities)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>
Returns
Section titled “Returns”DeleteByKey<T>(IDbLink, object)
Section titled “DeleteByKey<T>(IDbLink, object)”public static int DeleteByKey(this IDbLink link, this object key)Parameters
Section titled “Parameters”Returns
Section titled “Returns”DeleteByKey<T>(IDbLink, object[])
Section titled “DeleteByKey<T>(IDbLink, object[])”public static int DeleteByKey(this IDbLink link, this object[] key)Parameters
Section titled “Parameters”Returns
Section titled “Returns”DeleteManyByKey<T>(IDbLink, IEnumerable<object>)
Section titled “DeleteManyByKey<T>(IDbLink, IEnumerable<object>)”public static int DeleteManyByKey(this IDbLink link, this IEnumerable<object> recordsKeys)Parameters
Section titled “Parameters”linkIDbLinkrecordsKeysIEnumerable<object>
Returns
Section titled “Returns”DeleteManyByKey<T>(IDbLink, IEnumerable<object[]>)
Section titled “DeleteManyByKey<T>(IDbLink, IEnumerable<object[]>)”public static int DeleteManyByKey(this IDbLink link, this IEnumerable<object[]> recordsKeys)Parameters
Section titled “Parameters”linkIDbLinkrecordsKeysIEnumerable<object[]>
Returns
Section titled “Returns”EntityQuery<TSource>(IDbLink)
Section titled “EntityQuery<TSource>(IDbLink)”public static IOrderedQueryable<TSource> EntityQuery(this IDbLink link)Parameters
Section titled “Parameters”linkIDbLink
Returns
Section titled “Returns”IOrderedQueryable<TSource>
Execute(IDbLink, string, object[])
Section titled “Execute(IDbLink, string, object[])”public static QueryResult Execute(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Execute<T>(IDbLink, string, object[])
Section titled “Execute<T>(IDbLink, string, object[])”public static QueryObjectResult<T> Execute(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Execute<T>(IDbLink, IQuerySource)
Section titled “Execute<T>(IDbLink, IQuerySource)”public static QueryObjectResult<T> Execute(this IDbLink link, this IQuerySource query)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySource
Returns
Section titled “Returns”Execute<T>(IDbLink, IQuerySource, QueryObjectResultPropertyResolver)
Section titled “Execute<T>(IDbLink, IQuerySource, QueryObjectResultPropertyResolver)”public static QueryObjectResult<T> Execute(this IDbLink link, this IQuerySource query, this QueryObjectResultPropertyResolver customPropertyResolver)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySourcecustomPropertyResolverQueryObjectResultPropertyResolver
Returns
Section titled “Returns”Execute<T>(IDbLink, IQuerySource, QueryObjectResultPropertyResolver, QueryObjectResultItemFiller<T>)
Section titled “Execute<T>(IDbLink, IQuerySource, QueryObjectResultPropertyResolver, QueryObjectResultItemFiller<T>)”public static QueryObjectResult<T> Execute(this IDbLink link, this IQuerySource query, this QueryObjectResultPropertyResolver customPropertyResolver, this QueryObjectResultItemFiller<T> additionalFiller)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySourcecustomPropertyResolverQueryObjectResultPropertyResolveradditionalFillerQueryObjectResultItemFiller<T>
Returns
Section titled “Returns”ExecuteColumnScalars(IDbLink, string, object[])
Section titled “ExecuteColumnScalars(IDbLink, string, object[])”public static IList<object> ExecuteColumnScalars(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”ExecuteColumnScalars<T>(IDbLink, string, object[])
Section titled “ExecuteColumnScalars<T>(IDbLink, string, object[])”public static IList<T> ExecuteColumnScalars(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”IList<T>
ExecuteColumnScalars<T>(IDbLink, IQuerySource)
Section titled “ExecuteColumnScalars<T>(IDbLink, IQuerySource)”public static IList<T> ExecuteColumnScalars(this IDbLink link, this IQuerySource query)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySource
Returns
Section titled “Returns”IList<T>
ExecuteColumnScalars(IDbLink, IQuerySource)
Section titled “ExecuteColumnScalars(IDbLink, IQuerySource)”public static IList<object> ExecuteColumnScalars(this IDbLink link, this IQuerySource query)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySource
Returns
Section titled “Returns”ExecuteNonQuery(IDbLink, string, object[])
Section titled “ExecuteNonQuery(IDbLink, string, object[])”public static int ExecuteNonQuery(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”ExecuteRowScalars(IDbLink, string, object[])
Section titled “ExecuteRowScalars(IDbLink, string, object[])”public static IList<object> ExecuteRowScalars(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”ExecuteRowScalars<T>(IDbLink, string, object[])
Section titled “ExecuteRowScalars<T>(IDbLink, string, object[])”public static IList<T> ExecuteRowScalars(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”IList<T>
ExecuteRowScalars<T>(IDbLink, IQuerySource)
Section titled “ExecuteRowScalars<T>(IDbLink, IQuerySource)”public static IList<T> ExecuteRowScalars(this IDbLink link, this IQuerySource query)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySource
Returns
Section titled “Returns”IList<T>
ExecuteRowScalars(IDbLink, IQuerySource)
Section titled “ExecuteRowScalars(IDbLink, IQuerySource)”public static IList<object> ExecuteRowScalars(this IDbLink link, this IQuerySource query)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySource
Returns
Section titled “Returns”ExecuteScalar(IDbLink, string, object[])
Section titled “ExecuteScalar(IDbLink, string, object[])”public static object ExecuteScalar(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”ExecuteScalar<T>(IDbLink, string, object[])
Section titled “ExecuteScalar<T>(IDbLink, string, object[])”public static T ExecuteScalar(this IDbLink link, this string queryFormat, this object[] agrs)Parameters
Section titled “Parameters”Returns
Section titled “Returns”T
ExecuteScalar<T>(IDbLink, IQuerySource)
Section titled “ExecuteScalar<T>(IDbLink, IQuerySource)”public static T ExecuteScalar(this IDbLink link, this IQuerySource query)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySource
Returns
Section titled “Returns”T
Fill(IDbLink, IQuerySource, DataTable)
Section titled “Fill(IDbLink, IQuerySource, DataTable)”public static int Fill(this IDbLink link, this IQuerySource query, this DataTable dataTable)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySourcedataTableDataTable
Returns
Section titled “Returns”Fill(IDbLink, IQuerySource, DataSet)
Section titled “Fill(IDbLink, IQuerySource, DataSet)”public static int Fill(this IDbLink link, this IQuerySource query, this DataSet dataSet)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySourcedataSetDataSet
Returns
Section titled “Returns”Fill(IDbLink, IQuerySource, DataSet, string)
Section titled “Fill(IDbLink, IQuerySource, DataSet, string)”public static int Fill(this IDbLink link, this IQuerySource query, this DataSet dataSet, this string sourceTableName)Parameters
Section titled “Parameters”linkIDbLinkqueryIQuerySourcedataSetDataSetsourceTableNamestring
Returns
Section titled “Returns”GetByKey<T>(IDbLink, object)
Section titled “GetByKey<T>(IDbLink, object)”public static T GetByKey(this IDbLink link, this object key)Parameters
Section titled “Parameters”Returns
Section titled “Returns”T
GetByKey<T>(IDbLink, object[])
Section titled “GetByKey<T>(IDbLink, object[])”public static T GetByKey(this IDbLink link, this object[] key)Parameters
Section titled “Parameters”Returns
Section titled “Returns”T
GetManyByKey<T>(IDbLink, IEnumerable<object>)
Section titled “GetManyByKey<T>(IDbLink, IEnumerable<object>)”public static IList<T> GetManyByKey(this IDbLink link, this IEnumerable<object> recordsKeys)Parameters
Section titled “Parameters”linkIDbLinkrecordsKeysIEnumerable<object>
Returns
Section titled “Returns”IList<T>
GetManyByKey<T>(IDbLink, IEnumerable<object[]>)
Section titled “GetManyByKey<T>(IDbLink, IEnumerable<object[]>)”public static IList<T> GetManyByKey(this IDbLink link, this IEnumerable<object[]> recordsKeys)Parameters
Section titled “Parameters”linkIDbLinkrecordsKeysIEnumerable<object[]>
Returns
Section titled “Returns”IList<T>
GetSchemaModel(IDbLink)
Section titled “GetSchemaModel(IDbLink)”public static DbSchema GetSchemaModel(this IDbLink link)Parameters
Section titled “Parameters”linkIDbLink
Returns
Section titled “Returns”Insert<T>(IDbLink, T)
Section titled “Insert<T>(IDbLink, T)”public static int Insert(this IDbLink link, this T entity)Parameters
Section titled “Parameters”linkIDbLinkentityT
Returns
Section titled “Returns”Insert<T>(IDbLink, T, IList<string>, bool)
Section titled “Insert<T>(IDbLink, T, IList<string>, bool)”public static int Insert(this IDbLink link, this T entity, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Insert<T>(IDbLink, IEnumerable<T>)
Section titled “Insert<T>(IDbLink, IEnumerable<T>)”public static int Insert(this IDbLink link, this IEnumerable<T> entities)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>
Returns
Section titled “Returns”Insert<T>(IDbLink, IEnumerable<T>, IList<string>, bool)
Section titled “Insert<T>(IDbLink, IEnumerable<T>, IList<string>, bool)”public static int Insert(this IDbLink link, this IEnumerable<T> entities, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>propertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”InsertReturning<T>(IDbLink, T)
Section titled “InsertReturning<T>(IDbLink, T)”public static T InsertReturning(this IDbLink link, this T entity)Parameters
Section titled “Parameters”linkIDbLinkentityT
Returns
Section titled “Returns”T
InsertReturning<T>(IDbLink, T, IList<string>, bool)
Section titled “InsertReturning<T>(IDbLink, T, IList<string>, bool)”public static T InsertReturning(this IDbLink link, this T entity, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”Returns
Section titled “Returns”T
InsertReturning<T>(IDbLink, IEnumerable<T>)
Section titled “InsertReturning<T>(IDbLink, IEnumerable<T>)”public static IList<T> InsertReturning(this IDbLink link, this IEnumerable<T> entities)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>
Returns
Section titled “Returns”IList<T>
InsertReturning<T>(IDbLink, IEnumerable<T>, IList<string>, bool)
Section titled “InsertReturning<T>(IDbLink, IEnumerable<T>, IList<string>, bool)”public static IList<T> InsertReturning(this IDbLink link, this IEnumerable<T> entities, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>propertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”IList<T>
ParseEntityQuery<TSource>(IDbLink, IQueryable<TSource>)
Section titled “ParseEntityQuery<TSource>(IDbLink, IQueryable<TSource>)”public static SqlQuerySelect ParseEntityQuery(this IDbLink link, this IQueryable<TSource> queryable)Parameters
Section titled “Parameters”linkIDbLinkqueryableIQueryable<TSource>
Returns
Section titled “Returns”Update<T>(IDbLink, T)
Section titled “Update<T>(IDbLink, T)”public static int Update(this IDbLink link, this T entity)Parameters
Section titled “Parameters”linkIDbLinkentityT
Returns
Section titled “Returns”Update<T>(IDbLink, T, IList<string>, bool)
Section titled “Update<T>(IDbLink, T, IList<string>, bool)”public static int Update(this IDbLink link, this T entity, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Update<T>(IDbLink, IEnumerable<T>)
Section titled “Update<T>(IDbLink, IEnumerable<T>)”public static int Update(this IDbLink link, this IEnumerable<T> entities)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>
Returns
Section titled “Returns”Update<T>(IDbLink, IEnumerable<T>, IList<string>, bool)
Section titled “Update<T>(IDbLink, IEnumerable<T>, IList<string>, bool)”public static int Update(this IDbLink link, this IEnumerable<T> entities, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>propertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”UpdateReturning<T>(IDbLink, T)
Section titled “UpdateReturning<T>(IDbLink, T)”public static T UpdateReturning(this IDbLink link, this T entity)Parameters
Section titled “Parameters”linkIDbLinkentityT
Returns
Section titled “Returns”T
UpdateReturning<T>(IDbLink, T, IList<string>, bool)
Section titled “UpdateReturning<T>(IDbLink, T, IList<string>, bool)”public static T UpdateReturning(this IDbLink link, this T entity, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”Returns
Section titled “Returns”T
UpdateReturning<T>(IDbLink, IEnumerable<T>)
Section titled “UpdateReturning<T>(IDbLink, IEnumerable<T>)”public static IList<T> UpdateReturning(this IDbLink link, this IEnumerable<T> entities)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>
Returns
Section titled “Returns”IList<T>
UpdateReturning<T>(IDbLink, IEnumerable<T>, IList<string>, bool)
Section titled “UpdateReturning<T>(IDbLink, IEnumerable<T>, IList<string>, bool)”public static IList<T> UpdateReturning(this IDbLink link, this IEnumerable<T> entities, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>propertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”IList<T>
Upsert<T>(IDbLink, T, DbUpsertMode)
Section titled “Upsert<T>(IDbLink, T, DbUpsertMode)”public static int Upsert(this IDbLink link, this T entity, this DbUpsertMode mode)Parameters
Section titled “Parameters”linkIDbLinkentityTmodeDbUpsertMode
Returns
Section titled “Returns”Upsert<T>(IDbLink, T, DbUpsertMode, IList<string>, bool)
Section titled “Upsert<T>(IDbLink, T, DbUpsertMode, IList<string>, bool)”public static int Upsert(this IDbLink link, this T entity, this DbUpsertMode mode, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentityTmodeDbUpsertModepropertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”Upsert<T>(IDbLink, IEnumerable<T>, DbUpsertMode)
Section titled “Upsert<T>(IDbLink, IEnumerable<T>, DbUpsertMode)”public static int Upsert(this IDbLink link, this IEnumerable<T> entities, this DbUpsertMode mode)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>modeDbUpsertMode
Returns
Section titled “Returns”Upsert<T>(IDbLink, IEnumerable<T>, DbUpsertMode, IList<string>, bool)
Section titled “Upsert<T>(IDbLink, IEnumerable<T>, DbUpsertMode, IList<string>, bool)”public static int Upsert(this IDbLink link, this IEnumerable<T> entities, this DbUpsertMode mode, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>modeDbUpsertModepropertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”UpsertReturning<T>(IDbLink, T, DbUpsertMode)
Section titled “UpsertReturning<T>(IDbLink, T, DbUpsertMode)”public static T UpsertReturning(this IDbLink link, this T entity, this DbUpsertMode mode)Parameters
Section titled “Parameters”linkIDbLinkentityTmodeDbUpsertMode
Returns
Section titled “Returns”T
UpsertReturning<T>(IDbLink, T, DbUpsertMode, IList<string>, bool)
Section titled “UpsertReturning<T>(IDbLink, T, DbUpsertMode, IList<string>, bool)”public static T UpsertReturning(this IDbLink link, this T entity, this DbUpsertMode mode, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentityTmodeDbUpsertModepropertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”T
UpsertReturning<T>(IDbLink, IEnumerable<T>, DbUpsertMode)
Section titled “UpsertReturning<T>(IDbLink, IEnumerable<T>, DbUpsertMode)”public static IList<T> UpsertReturning(this IDbLink link, this IEnumerable<T> entities, this DbUpsertMode mode)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>modeDbUpsertMode
Returns
Section titled “Returns”IList<T>
UpsertReturning<T>(IDbLink, IEnumerable<T>, DbUpsertMode, IList<string>, bool)
Section titled “UpsertReturning<T>(IDbLink, IEnumerable<T>, DbUpsertMode, IList<string>, bool)”public static IList<T> UpsertReturning(this IDbLink link, this IEnumerable<T> entities, this DbUpsertMode mode, this IList<string> properties, this bool excludeProperties)Parameters
Section titled “Parameters”linkIDbLinkentitiesIEnumerable<T>modeDbUpsertModepropertiesIList<string>excludePropertiesbool
Returns
Section titled “Returns”IList<T>