code_junkie

Linq2SQL: Update object not created in datacontext

Nov 13th, 2011
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. public static void Save(Client client)
  2. {
  3. CompanyDataContext db = new CompanyDataContext();
  4. Validate(client);
  5. if(client.Id.Equals(Guid.Empty))
  6. {
  7. //Create (right?):
  8. client.Id = Guid.NewGuid();
  9. db.Clients.InsertOnSubmit(client);
  10. db.SubmitChanges();
  11. }
  12. else
  13. {
  14. //Update:
  15. OffertaDataContext db = new OffertaDataContext();
  16. db.Clients.????
  17.  
  18. }
  19. }
  20.  
  21. ctx.Customers.Attach(customer); // optional bool to treat as modified
  22.  
  23. public override IEnumerable(memberState) GetMembersByState(string @state)<br/>
  24. {<br/>
  25. using (BulletinWizardDataContext context = DataContext)<br/>
  26. {<br/>
  27. IEnumerable(memberState) mems = (from m in context.Members<br/>
  28. join ma in context.MemberAddresses<br/>
  29. on m.UserId equals ma.UserId<br/>
  30. join s in context.States<br/>
  31. on ma.StateId equals s.StateId<br/>
  32. where s.StateName == @state<br/>
  33. select new memberState<br/>
  34. {<br/>
  35. userId = m.UserID,<br/>
  36. firstName = m.FirstName,<br/>
  37. middleInitial = m.MiddleInitial,<br/>
  38. lastName = m.LastName,<br/>
  39. createDate = m.CreateDate,<br/>
  40. modifyDate = m.ModifyDate<br/>
  41. }).ToArray(memberState)();<br/>
  42. return mems;
  43. }
  44. }
Add Comment
Please, Sign In to add comment