public static List <object> getJson() { JsonSerializerSettings settings = new JsonSerializerSettings(); settings.Formatting = Formatting.Indented; settings.AddSqlConverters(); List <object> tmpL = new List <object>(); foreach (var item in Main_List) { var val = item.Value; if (val.Count > 0) { for (int i = 0; i < val.Count; i += STEP) { Dictionary <string, Dictionary <string, List <object> > > _List = new Dictionary <string, Dictionary <string, List <object> > >(); var end = STEP; if (val.Count <= i + STEP) { end = val.Count - i; } var tmpDict = new Dictionary <string, List <object> >(); tmpDict.Add(item.Key, item.Value.GetRange(i, end)); //Console.WriteLine("tmpDict Length"); //foreach (var term in tmpDict.Keys) //{ // Console.WriteLine(tmpDict[term].Count); //} _List.Add(city_code, tmpDict); var json_item = JsonConvert.SerializeObject(_List, settings); tmpL.Add(json_item); } Console.WriteLine("Item Length"); Console.WriteLine(val.Count); Console.WriteLine("\n"); //using (FileStream f = new FileStream(String.Format("./Data/Length.txt"), FileMode.Append, FileAccess.Write, FileShare.None)) //{ // using (StreamWriter sw = new StreamWriter(f)) // { // sw.Write(item.Key.ToString() + ": "); // sw.WriteLine(val.Count); // } //} } else { list_clear(); break; } } return(tmpL); }
public async Task ConnectAsync() { _logger.LogInformation("Connecting to SQL Server..."); _sqlConnection = new SqlConnection(_config.SourceSqlConnectionString); _logger.LogInformation("Done"); _logger.LogInformation("Connecting to Couchbase..."); var serializerSettings = new JsonSerializerSettings(); serializerSettings.AddSqlConverters(); var options = new ClusterOptions { UserName = _config.TargetUsername, Password = _config.TargetPassword, Serializer = new DefaultSerializer(serializerSettings, serializerSettings) }; _cluster = await Cluster.ConnectAsync(_config.TargetConnectionString, options); _logger.LogInformation("Done"); }