示例#1
0
        public string BulkInsertCmd <T>(List <T> items)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.AppendLine($"INSERT INTO {nameof(Contact)}({BulkHelper.CommaSeparatedPropertiesNameFromType(typeof(Contact))})");

            items.ForEach(item =>
            {
                stringBuilder.AppendLine($"SELECT {BulkHelper.CommaSeparatedPropertiesValueFromObject(item)}{BulkHelper.CmdLineDelimiter(items, item)}");
            });

            return(stringBuilder.ToString());
        }