var i = 1;
var houses = _houseNumsNames.Select(name => new HouseNum() { Id = i++, Name = name }).ToList();
_back.HouseNumbers.AddRange(houses);public void AddRange(IEnumerable<HouseNum> items)
{
var list = items.Select(item => new DbHouseNum() { Id = item.Id, Name = item.Name });
_ctx.HouseNums.BulkMerge(list, o =>
{
o.ColumnPrimaryKeyExpression = c => c.Id;
o.BatchSize = 1000;
o.CaseSensitive = CaseSensitiveType.Sensitive;
});
}select ID, Name from HOUSE_HOUSENUM
where Name = '32Д' COLLATE Cyrillic_General_BIN2select ID, Name from HOUSE_HOUSENUM
where Name = '32Д'