Implementation of big data insert Code sharing in C #

This article mainly explains "C # to achieve big data insert code sharing", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "C # to achieve big data plug-in code sharing"!

Public static void BulkInsert (string connection, string tableName, IList list)

{using (var bulkCopy = new SqlBulkCopy (connection)) {bulkCopy.BatchSize = list.Count; bulkCopy.DestinationTableName = tableName; var table = new DataTable () Var props = TypeDescriptor.GetProperties (typeof (T)) .Cast () .Where (propertyInfo = > propertyInfo.PropertyType.Namespace.Equals ("System")) .ToArray () Foreach (var propertyInfo in props) {bulkCopy.ColumnMappings.Add (propertyInfo.Name, propertyInfo.Name); table.Columns.Add (propertyInfo.Name, Nullable.GetUnderlyingType (propertyInfo.PropertyType)? PropertyInfo.PropertyType);} var values = new object [props.Length]; foreach (var item in list) {for (var I = 0; I < values.Length; I +) {values [I] = props [I] .GetValue (item) } table.Rows.Add (values);} bulkCopy.WriteToServer (table);}} at this point, I believe you have a deeper understanding of "C# big data plug-in code sharing". You might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!