private static void LoadDataInSQLServer(string filepath) { var businesses = File.ReadAllLines(filepath); var srv = new ElasticSearchService(); var cnt = businesses.Length; foreach (var line in businesses) { if (line.Length > 150) { continue; } var k = new Business { Name = line.Trim(), Code = Util.TimeStampCode("BIZ") }; _context.Businesses.Add(k); _context.SaveChanges(); cnt--; Console.WriteLine("Remains: " + cnt); srv.IndexBusinessSync(k); } }