public void Dispose() { _context.Database.EnsureDeleted(); _context.Dispose(); _emptyContext.Database.EnsureDeleted(); _emptyContext.Dispose(); }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
protected virtual void CleabData(bool disposing) { if (_disposed) { return; } if (disposing) { } _context.Dispose(); _disposed = true; }
public void EFDBContextTest() { var db = new EFDBContext(); //编辑用户组 //var role = db.SysRoles.Where(p => p.ID == 2).Include(s => s.SysRoleRoutes.Select(y => y.SysRoute)).FirstOrDefault(); //添加测试路由 //int[] power = { (int)DataCore.Entity.SysRouteType.add, (int)DataCore.Entity.SysRouteType.delete, (int)DataCore.Entity.SysRouteType.select }; //int[] power2 = { (int)DataCore.Entity.SysRouteType.update, (int)DataCore.Entity.SysRouteType.upload }; //var route1 = new DataCore.Entity.SysRoute() { AddTime = DateTime.Now, Desc = "测试路由", Route = "/home/index", Tag = "其他", RouteType = power }; //var route2 = new DataCore.Entity.SysRoute() { AddTime = DateTime.Now, Desc = "测试路由2", Route = "/home/test", Tag = "其他2", RouteType = power2 }; //db.SysRoutes.Add(route1); //db.SysRoutes.Add(route2); //添加组对应权限 //var roleroute = new DataCore.Entity.SysRoleRoute() { SysRoleID = role.ID, SysRoute = route1 }; //var roleroute2 = new DataCore.Entity.SysRoleRoute() { SysRoleID = role.ID, SysRoute = route2 }; //db.SysRoleRoutes.Add(roleroute); //db.SysRoleRoutes.Add(roleroute2); //添加用户 var entity = db.SysRoles.Find(2); string pwd = SecureHelper.MD5("admin"); for (int i = 0; i < 30; i++) { var user = new Entity.SysUser() { Avatar = "", Gender = Entity.UserGender.男, LastLoginTime = DateTime.Now, NickName = "编辑用户" + (i + 1).ToString(), Password = pwd, RegTime = DateTime.Now, Status = true, SysRole = entity, UserName = "******" + (i + 1).ToString() }; db.SysUsers.Add(user); } db.SaveChanges(); //var group = db.SysRoutes.GroupBy(p => p.Tag).ToList(); db.Dispose(); Assert.AreEqual(1, 1); }
public void TestMethod1() { var db = new EFDBContext(); var category_list = db.CusCategorys.AsNoTracking().ToList(); db.Dispose(); List <Entity.CusCategory> new_list = new List <Entity.CusCategory>(); GetChilds(category_list, new_list, null); StringBuilder tree_str = new StringBuilder(); foreach (var item in new_list) { tree_str.Append(StringHelper.StringOfChar(item.Depth - 1, " ") + "├ " + StringHelper.StringOfChar(item.Depth - 1, " ") + item.Title + "\r\n"); //if(item.Depth == 1) // tree_str.Append(item.Title +"\r\n"); //else // tree_str.Append(StringHelper.StringOfChar(item.Depth - 1, " ")+"├ " + StringHelper.StringOfChar(item.Depth - 1, " ") + item.Title +"\r\n"); } Assert.AreEqual(1, 1); }
private List <string> SaveToBaseCSV(string nameCSV, string nameConfig) { // Load Data from csv file List <string> str = new List <string>(); DataTable csvData = GetDataCSV(nameCSV); // Load config from xml file DataSet ds = new DataSet(); ds.ReadXml(nameConfig); DataTable xmlData = new DataTable(); xmlData = ds.Tables[0]; // ReLoad Data from csv table to DB by field from xml config file using (EFDBContext dbContext = new EFDBContext()) { var st = from myZip in csvData.AsEnumerable() where myZip.Field <string>("Бренд") == "555" select myZip; IEnumerable <string> fldVendor = from p in xmlData.AsEnumerable() where p.Field <string>("FIELD") == "Vendor" select p.Field <string>("SOURCE"); IEnumerable <string> fldNumber = from p in xmlData.AsEnumerable() where p.Field <string>("FIELD") == "Number" select p.Field <string>("SOURCE"); IEnumerable <string> fldDescription = from p in xmlData.AsEnumerable() where p.Field <string>("FIELD") == "Description" select p.Field <string>("SOURCE"); IEnumerable <string> fldPrice = from p in xmlData.AsEnumerable() where p.Field <string>("FIELD") == "Price" select p.Field <string>("SOURCE"); IEnumerable <string> fldCount = from p in xmlData.AsEnumerable() where p.Field <string>("FIELD") == "Count" select p.Field <string>("SOURCE"); foreach (DataRow row in csvData.Rows) { string vendor = row.Field <string>(fldVendor.First()); string number = row.Field <string>(fldNumber.First()); string schVendor = Regex.Replace(row.Field <string>(fldVendor.First()), @"[^A-Za-zА-Яа-я0-9]+", "").ToUpper(); string schNumber = Regex.Replace(row.Field <string>(fldNumber.First()), @"[^A-Za-zА-Яа-я0-9]+", "").ToUpper(); string description = row.Field <string>(fldDescription.First()); string strPrice = row.Field <string>(fldPrice.First()).Replace(",", "."); int count = Convert.ToInt32(Regex.Match(row.Field <string>(fldCount.First()), @"[0-9]+$").Value); string query = $"INSERT INTO ZipItems (Vendor, Number, SearchVendor, SearchNumber, Description, Price, Count) VALUES (N'{vendor}', N'{number}', N'{schVendor}', N'{schNumber}', N'{description}', {strPrice}, {count})"; int qan = dbContext.Database.ExecuteSqlCommand(query); } //"INSERT INTO ZipItems (Vendor, Number, Description, Price, Count) VALUES (@vendor, 'SA-1712L', '666', 'SA1712L', 'Рычаг подвески | перед лев |', '1343', '2')"; //int qan = dbContext.Database.ExecuteSqlCommand(query); dbContext.Dispose(); } ViewBag.Table = xmlData; return(str); }
public void Dispose() { _context.Dispose(); }