public void InsertUserRole() { IdentityUser user = new IdentityUser { UserName = "******", Email = "*****@*****.**", PhoneNumber = "1234567890", PasswordHash = "@#$rfgt$##WE", EmailConfirmed = true, PhoneNumberConfirmed = true, TwoFactorEnabled = false, LockoutEnabled = false, AccessFailedCount = 0 }; user = userTable.Insert(user); dynamic role = new { Name = "Admin" }; role = roleTable.Insert(role); object userRole = new { UserId = user.Id, RoleId = role.Id }; userRole = userRoleTable.Insert(userRole); int count = userRoleTable.All($"UserId={user.Id} and RoleId={role.Id}").ToList().Count; Assert.AreEqual(1, count); }