Insert record into db using linq2sql/datacontext

Question

Hi there,

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;
    }

Answer 1

try

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

Answer 2

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;
}

Answer 3

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

Answer 4

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