Hello,
I am inserting data from database first method.
I have 3 tables.
1. UserMaster 2. roles 3. UserRoles.
When i create edmx it create the model like below:
public partial class UserRole
{
public int UserRoleID { get; set; }
public virtual Role Role { get; set; }
public virtual User User { get; set; }
}
public partial class User
{
public User()
{
this.UserRoles = new HashSet<UserRole>();
}
public string UserID { get; set; }
public string EmailAddress { get; set; }
public Nullable<System.DateTime> CreatedDate { get; set; }
public string CreatedBy { get; set; }
public virtual ICollection<UserRole> UserRoles { get; set; }
}
public partial class Role
{
public Role()
{
this.UserRoles = new HashSet<UserRole>();
}
public int RoleID { get; set; }
public string RoleName { get; set; }
public virtual ICollection<UserRole> UserRoles { get; set; }
}
Now when i insert data bt this:
Role obj_role = new Role();
var roles = ent.Roles.Where(m => m.RoleID == model.RoleID);
foreach (var item in roles)
{
obj_role.RoleID = item.RoleID;
obj_role.RoleName = item.RoleName;
}
User obj_user = new User();
obj_user.UserID = model.LoginName;
obj_user.EmailAddress = model.EmailAddress;
UserRole obj_UserRole = new UserRole();
obj_UserRole.User = obj_user;
obj_UserRole.Role = obj_role;
obj_user.UserRoles.Add(obj_UserRole);
obj_role.UserRoles.Add(obj_UserRole);
ent.Users.Add(obj_user);
ent.SaveChanges();
But every time it create new record in Roles table.
please suggest..