Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL LINQ Silverlight , +
I am using C# SilverLight to create an application where I whould like to insert data into a database table. How do I do this in Linq-to-SQL?
 
My database table:
http://bildr.no/view/1412875[^]
 
My code:
/// <summary>
/// GetAllCarts
/// Sends all carts in database to list
/// </summary>
[OperationContract]
List<Lloyds_Cart> GetAllCarts()
{
    PositionDataClassesDataContext context = new PositionDataClassesDataContext();
 
    var res = from carts in context.Lloyds_Carts select carts;
 
    return res.ToList();
 
}
/// <summary>
/// Create a new Cart
/// </summary>
[OperationContract]
void CreateCart()
{
    PositionDataClassesDataContext context = new PositionDataClassesDataContext();
}
Posted 11-Mar-13 4:44am
Edited 11-Mar-13 5:32am
v2
Comments
sjelen at 11-Mar-13 10:20am
   
What have you tried? What is the problem?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try like this
context.Lloyds_Carts.InsertOnSubmit(Lloyds_Cart);
 
context.SubmitChanges();
 
Where Lloyds_Cart is the entity that you need to pass on the InsertOnSubmit method
 
Hope this helps
  Permalink  
Comments
Solo1233211 at 12-Mar-13 5:19am
   
[OperationContract]
void CreateCart()
{
PositionDataClassesDataContext context = new PositionDataClassesDataContext();
 
context.Lloyds_Carts.InsertOnSubmit(Lloyds_Cart);
 
context.SubmitChanges();
 
}
 
That does not work.
Jameel Moideen at 12-Mar-13 11:15am
   
What' the error showing?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

i want to know the actuall mapping coding
 
because mine is showing errors
  Permalink  
Comments
Sergey Alexandrovich Kryukov at 8-May-13 15:37pm
   
You should not post such content as "answer".
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 280
1 Sergey Alexandrovich Kryukov 279
2 CPallini 205
3 Maciej Los 197
4 Afzaal Ahmad Zeeshan 160
0 OriginalGriff 5,635
1 DamithSL 4,496
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 22 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100