lion_6的专栏

Dapper Plus - Bulk MergeDescriptionMERGE entities using Bulk Operation.Merge single Merge many Merge with relation (One to One) Merge with relation (One to Many)Example - Merge Single...

Dapper Plus - Bulk DeleteDescriptionDELETE entities using Bulk Operation.Delete single Delete many Delete with relation (One to One) Delete with relation (One to Many)Example - Delete ...

Dapper Plus - Bulk UpdateDescriptionUPDATE entities using Bulk Operation.Update single Update many Update with relation (One to One) Update with relation (One to Many)Example - Update ...

Dapper Plus - Bulk InsertDescriptionINSERT entities using Bulk Operation.Insert single Insert many Insert with relation (One to One) Insert with relation (One to Many)Example - Insert ...

背景：在前面两篇博文《SQL Server 大数据管理——数据归档(主文件备份)》、《SQL Server 大数据管理——数据归档(段落备份)》中，表分区在其中起到了主要作用，本文将介绍分区的实现及表分区的相关属性和操作。一. 创建分区文件组/文件 --创建分区文件组 alter database test add filegroup test2015 al...

SELECT  creation_time  N'语句编译时间'        ,last_execution_time  N'上次执行时间'        ,execution_count  N'执行次数'        ,case datediff(ss,creation_time,last_execution_time) when 0 then 0             e

public static void BulkToDB(DataTable dt)  {      SqlConnection sqlConn = new SqlConnection(          ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString);      SqlBulkCopy bulk

using System;using System.Data;using System.Collections;using System.Collections.Generic;using System.Configuration;using System.Reflection;using System.Linq;using System.Xml.Linq;na