MVC 5, Entity Framework 6 and Many to Many Relationship

Mouhssine tahri

5y825.NET

I've two model classes:

public Service()
public int CodeService { get; set; }
public string DesignationService { get; set; }
public virtual ICollection ServiceToUser { get; set; }
public User()
public int UserID { get; set; }
public string FirstName { get; set; }
public virtual ICollection UserToService { get; set; }
}

The above code generates me 3 tables Service, User & ServiceUsers(autogenerated by EF)

i want insert in UserID = 5 and CodeService = 8 in ServiceUsers table.()

values 5 already exist in table User

values 8 already exist in table Service

i use webapi

var apiurl = "http://localhost:14405/api/ServiceApi";
var data = {
DesignationService: $("#description").val(),
serviceToUser: user // usr is list of user with userid=5
}
$.ajax({
url: apiurl,
type: 'POST',
dataType: 'json',
data: data,
success: function (d) {
noty({ text: 'Association réussie', layout: 'topRight', type: 'success'
});
},
error: function () {
noty({ text: 'Association échouée', layout: 'topRight', type: 'error' });
}
});
public void addService(Service service)
{
Attach(service);
bd.Service.Add(service);
bd.SaveChanges();
}
private void Attach(Service service)
{
int l = service.ServiceToUser.Count();
for (int i = 0; i < l; i++)
{
bd.User.Attach(service.ServiceToUser.ElementAt(i));
}
}

but when addService is executed it create a new record in service table value 6 and in ServiceUsers table it create 6 for code service and 5 in userid.

can you help me to solve this problem.

I want only insert ServiceUsers

thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
as far as i can understand
you want to assign service i.e. of ServiceCode 8 to a user of UserId 5 .
Then do it like
User user=Context.Users.Find(5);
Service service =Context.Services.Find(8);
user.Services.Attach(service);
Context.Entity(User).State=EntityState.Modified;
Context.SaveChanges().
Mouhssine tahri5y ago
thanks for help.
now i want insert in bridge table many userid and codeservice in the same time
Sachin Singh5y ago
The updated codeto insert data to many to many table only
User user=Context.Users.Find(5);
Service service =Context.Services.Find(8);
user.Services.Add(service);
Context.Entity(User).State=EntityState.Modified;
Context.SaveChanges().
Mouhssine tahri5y ago
i have problem with Entity in this line
bd = new GestionCourrierEntities();
bd.Entity(user).State = EntityState.Modified;
Sachin Singh5y ago
yes it will add only in bridge table, just use this.
Mouhssine tahri5y ago
thanks for replay and excuse my bad english
i select from list1 userid and from list2 serviceid and i want add this record only in table serviceuser