private static void InsertRandom() { var rnd = new Random(); var dimValues = new List <string>(); for (var ii = 1; ii <= 50; ii++) { dimValues.Add("Value " + ii); } var timer = Stopwatch.StartNew(); using (var repo = new DatastoreRepository <MyItem>(repoID, SERVER, PORT)) { var list = new List <MyItem>(); for (var ii = 0; ii < 50; ii++) { var ID = rnd.Next() % 9999999; var newItem = new MyItem { Project = "Hello" + ID, Field1 = "V-" + (rnd.Next() % 5), ID = ID, MyList = new string[] { "aa", "bb" }, CreatedDate = DateTime.Now.AddMinutes(-_rnd.Next(0, 10000)), Dim2 = "Dim2-" + (rnd.Next() % 10), MyBool = (rnd.Next(100) % 2 == 0) ? true : false, MyFloat = rnd.Next(1, 10000), MyGeo = new GeoCode { Latitude = rnd.Next(-90, 90), Longitude = rnd.Next(-90, 90) }, MyBool2 = (rnd.Next(100) % 2 == 0) ? true : false, MyFloat2 = 2, MyFloat3 = 4, SomeInt2 = 5, MyByte = 40, MyShort = 99, MyDecimal = 66, MyDecimal2 = 33, MyLong = 17626, }; newItem.Dim2 = dimValues[rnd.Next(0, dimValues.Count)]; list.Add(newItem); } repo.InsertOrUpdate(list); timer.Stop(); Console.WriteLine($"Added Items: Elapsed={timer.ElapsedMilliseconds}"); } }
private static void AddData() { var rnd = new Random(); var dimValues = new List <string>(); for (var ii = 1; ii <= 50; ii++) { dimValues.Add("Value " + ii); } using (var repo = new DatastoreRepository <MyItem>(repoID, SERVER, PORT)) { //repo.ClearRepository(); var startTimestamp = repo.GetTimestamp(); var q = repo.Query.Results(); for (var ii = 0; ii < 50; ii++) { var newItem = new MyItem { Project = "Hello" + ii, Field1 = "V-" + (rnd.Next() % 5), ID = ii, MyList = new string[] { "aa", "bb" }, CreatedDate = DateTime.Now.AddMinutes(-_rnd.Next(0, 10000)), Dim2 = "Dim2-" + (rnd.Next() % 10), MyBool = (rnd.Next(100) % 2 == 0) ? true : false, MyFloat = rnd.Next(1, 10000), MyGeo = new GeoCode { Latitude = rnd.Next(-90, 90), Longitude = rnd.Next(-90, 90) }, MyBool2 = (rnd.Next(100) % 2 == 0) ? true : false, MyFloat2 = 2, MyFloat3 = 4, SomeInt2 = 5, MyByte = 40, MyShort = 99, MyDecimal = 66, MyDecimal2 = 33, MyLong = 17626, }; newItem.Dim2 = dimValues[rnd.Next(0, dimValues.Count)]; //repo.Delete.Where(X => X.ID == 1).Commit(); //newItem.Project = DateTime.Now.Ticks.ToString(); repo.InsertOrUpdate(newItem); //repo.Delete.Where(x => x.ID == ii).Commit(); //repo.Delete.Where(x => x.ID == 999).Commit(); Console.WriteLine($"Added Item {ii}"); } //repo.Delete.Where(x=>x.ID == -1).Commit(); //var diagnostics = repo.Update // .Field(x => x.Project, "") // .Field(x => x.Field1, "q") // .Where(x => x.ID == 1) // .Commit(); //var pp = 0; //if (1 == pp) //{ // repo.Delete.Where(x => x.__Timestamp < startTimestamp && x.ID == 5).Commit(); //} } }