insert/update/delete RSS

• 

  mexican

  Member

  190 Points

  1036 Posts

  • Reply
  •  

  insert/update/delete

  Nov 17, 2008 09:41 AM | LINK

  how do i insert/update/delete data with linq and silverlight?

  what are the linq commands?
  

  i know how to select and display data.
  

   

   

• 

  prujohn

  Contributor

  3609 Points

  713 Posts

  • Reply
  •  

  Re: insert/update/delete

  Nov 17, 2008 04:17 PM | LINK

  I found this link to be very helpful when I first started with Linq (101 Linq Samples):

  http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx

  Are trying to work with a SQL database? If so, then create a Linq-To-SQL (.dbml) in your project.  Add your database tables there.

  Then in code behind, you can create a datacontext object, which will allow you to work with your SQL Database.  Scott Guthrie has a great blog/tutorial about how to do this:  http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

  Thanks,
  John
  LUCA Studios
  
• 

  vinCracker

  Contributor

  4059 Points

  673 Posts

  • Reply
  •  

  Re: insert/update/delete

  Nov 19, 2008 10:14 AM | LINK

  Hi, Try the following links it will definitely get you working....

  http://www.codeproject.com/KB/silverlight/SilverlightWcfDatabase.aspx

  http://blogs.msdn.com/swiss_dpe_team/archive/2008/04/04/crud-operations-with-optimistic-locking-using-silverlight-2-beta1-wcf-and-linq-to-sql-inserts-updates-and-deletes.aspx 

   And for linq to SQL try these....

   http://msdn.microsoft.com/en-us/vbasic/bb688085.aspx

  http://weblogs.asp.net/scottgu/archive/2007/08/23/linq-to-sql-part-7-updating-our-database-using-stored-procedures.aspx (go through part 1 - 7 )

  -Vinit 

   

  Twitter | Vinit
  
  BounceBall - Game in WP7, XNA and Farseer Physics Engine
• 

  harsha2410

  Member

  2 Points

  3 Posts

  • Reply
  •  

  Re: Re: insert/update/delete

  Apr 22, 2010 01:13 PM | LINK

  its working like a charm. thanks a lot dude.