C# (CSharp) LinqToDB DataExtensions Examples

Example #1

 /// <summary>
 /// Inserts new record into table, identified by T mapping class, using values from obj parameter or update existing record, identified by match on primary key value.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="obj"></param>
 /// <param name="tableName"></param>
 /// <param name="databaseName"></param>
 /// <param name="schemaName"></param>
 /// <param name="serverName"></param>
 /// <param name="tableOptions"></param>
 /// <returns></returns>
 public int InsertOrReplace <T>(IEnumerable <T> obj, string tableName = null, string databaseName = null, string schemaName = null, string serverName = null, TableOptions tableOptions = TableOptions.NotSet) => ForEach(obj, item => DataExtensions.InsertOrReplace(this, item, tableName, databaseName, schemaName, serverName, tableOptions));

Example #2

 /// <summary>
 /// Asynchronously inserts new record into table, identified by T mapping class, using values from obj parameter or update existing record, identified by match on primary key value.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="obj"></param>
 /// <param name="tableName"></param>
 /// <param name="databaseName"></param>
 /// <param name="schemaName"></param>
 /// <param name="serverName"></param>
 /// <param name="tableOptions"></param>
 /// <param name="token"></param>
 /// <returns></returns>
 public async ValueTask <int> InsertOrReplaceAsync <T>(IEnumerable <T> obj, string tableName = null, string databaseName = null, string schemaName = null, string serverName = null, TableOptions tableOptions = TableOptions.NotSet, CancellationToken token = default) => await ForEach(obj, item => DataExtensions.InsertOrReplaceAsync(this, item, tableName, databaseName, schemaName, serverName, tableOptions, token));

Example #3

 /// <summary>
 /// Updates record in table, identified by T mapping class, using values from obj parameter. Record to update identified by match on primary key value from obj value.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="obj"></param>
 /// <returns></returns>
 public int Update <T>(IEnumerable <T> obj) => ForEach(obj, item => DataExtensions.Update(this, item));

Example #4

 /// <summary>
 /// Asynchronously updates record in table, identified by T mapping class, using values from obj parameter. Record to update identified by match on primary key value from obj value.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="obj"></param>
 /// <returns></returns>
 public async ValueTask <int> UpdateAsync <T>(IEnumerable <T> obj) => await ForEach(obj, item => DataExtensions.UpdateAsync(this, item));

Example #5

 public int Save <T>(T obj)
 {
     return(this.ExecutePack(() => DataExtensions.Insert(this, obj)));
 }

Example #6

 public int SaveWithInt32Identity <T>(T obj)
 {
     return(this.ExecutePack(() => DataExtensions.InsertWithInt32Identity(this, obj)));
 }

Example #7

 public int Save <T>(System.Collections.Generic.IEnumerable <T> obj) => this.ExecutePack(() => ForEach(obj, item => DataExtensions.Insert(this, item)));

Example #8

 public int Delete <T>(T obj)
 {
     return(this.ExecutePack(() => DataExtensions.Delete(this, obj)));
 }

Example #9

 public int Delete <T>(System.Collections.Generic.IEnumerable <T> obj)
 {
     return(this.ExecutePack(() => ForEach(obj, item => DataExtensions.Delete(this, item))));
 }

Example #10

 public int SaveOrUpdate <T>(T obj)
 {
     return(this.ExecutePack(() => DataExtensions.InsertOrReplace(this, obj)));
 }

Example #11

 public int SaveOrUpdate <T>(System.Collections.Generic.IEnumerable <T> obj)
 {
     return(this.ExecutePack(() => ForEach(obj, item => DataExtensions.InsertOrReplace(this, item))));
 }