Insert record into db using linq2sql/datacontext

Question

I am trying to insert a standard record into my db using linq2db, but i keep seeing examples to ADD method which i don't appear to have ... what i have currently is the following, as you can see i have my datacontext.... (no add method) ... the Reservation class is a separate class i created as a DTO - i presume this is correct?

Any help really appreciated,

    public bool AddReservation(Reservation reservation)
    {
        bool success = false;
        try
        {
            MiningDataContext db = new MiningDataContext();


            db.Reservations. // NO ADD HERE


        }
        catch { }

        return success;
    }

Ostemar · Accepted Answer · 2009-08-10 11:53:16Z

5

You should use the method InsertOnSubmit() and then call SubmitChanges().

public bool AddReservation(Reservation reservation)
{
    bool success = false;
    try
    {
        MiningDataContext db = new MiningDataContext();

        db.Reservations.InsertOnSubmit(reservation);
        db.SubmitChanges();

        ...

    }
    catch { }

    return success;
}

answered Aug 10, 2009 at 11:53

Ostemar

5,8282 gold badges21 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mark smith Over a year ago

Thanks .. yep thats there.. 1 question though... InsertOnSubmit takes a Reservation type... this can't be my Reservation DTO as i created this separately (its a dto) ... so i presume i have to do some kind of mapping??? I tried changing the namespace of Entity Classes but i can't seem to differenciate between "MY" reservation and the entity class reservation

Ostemar Over a year ago

Well, the data context (MiningDatacontext) expects an object of the Reservation class generated by LINQ to SQL. I just assumed you have a DBML-file where you mapped up your Reservations table? The output of that is both the DataContext and the entity classes. You can choose the namespace for those classes in the properties view when you have the DBML designer open.

mark smith Over a year ago

Yep this is true! just confirmed i was using a T4 tool to generate my DTOs which actually removes the generated Linq2sql stuff but the generated dtos are exactly the same just in a separate file... So i need to pass the Reservation DTO and it works... Thanks for the confirmation .. much appreciated

Ash M Over a year ago

Mark, can I ask what T4 template you use for this? We are currently doing this manually, and would love to know more about the T4 that you are using.

Arsen Mkrtchyan · Accepted Answer · 2009-08-10 11:52:55Z

1

try

db.Reservations.InsertOnSubmit(reservation);
db.SubmitChanges();

answered Aug 10, 2009 at 11:52

Arsen Mkrtchyan

50.9k33 gold badges155 silver badges187 bronze badges

3 Comments

mark smith Over a year ago

Thanks .. but what type is reservation .. it states "Reservation", of course i created a "RESERVATION" dto but how would linq2sql know this? I presume its talking about an entity called Reservation but i can't seem to find it, what namespace is it in?

mark smith Over a year ago

and more to the point, what if i don't have the DTO?... i am sure i can't pass anything here?? ... or can i pass anything that has the same "Field names" as properties?

Arsen Mkrtchyan Over a year ago

I am not sure that understand your question but will try to answer, it is auto generated classes, LINQ2SQL generates that classes for you

Web · Accepted Answer · 2009-08-10 11:56:27Z

0

Instead of doing db.Reservations.Add, just do Reservations.Add. Then use the db.SubmitChanges()

answered Aug 10, 2009 at 11:56

Web

1,7552 gold badges23 silver badges36 bronze badges

Comments

avnic · Accepted Answer · 2009-08-10 11:56:33Z

0

mybee you have compile errors within that class that was causing the intellisense to break i suggesting you to compile all the solution

anyway it should be InsertOnSubmit function

answered Aug 10, 2009 at 11:56

avnic

3,3918 gold badges39 silver badges46 bronze badges

Collectives™ on Stack Overflow

Insert record into db using linq2sql/datacontext

4 Answers 4

4 Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related