Shulou(Shulou.com)06/02 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.