Inserting data in a table with a auto increment key C# .NET Linq to SQL

Question

I want to input data into my table (sql 2008) using linq to sql:

    public static bool saveEmail(Emailadressen email)
    {
        TBL_Emailadressen saveMail = new TBL_Emailadressen();

        destil_loterijDataContext db = new destil_loterijDataContext();


        saveMail.naam = email.naam;
        saveMail.emailadres = email.emailadres;
        saveMail.lotnummer = email.lotnummer;



        try
        {
            saveMail.naam = email.naam;
            saveMail.lotnummer = email.lotnummer;
            saveMail.emailadres = email.emailadres;

            db.TBL_Emailadressens.InsertOnSubmit(saveMail);

            return true;

        }
        catch (Exception ex)
        {
            Console.WriteLine("Opslaan niet gelukt!" + ex.ToString());
            return false;
        }

    }

For some reason nothing is being added to this table. My table has the following fields:

ID (Auto incr int)

Naam (varchar50)

lotnummer (varchar50)

emailadres (varchar50)

My object im trying to save (saveMail) always has an ID = 0 , and i don't know why. I think that is preventing me from saving to the DB?

Anton Gogolev · Accepted Answer · 2010-02-12 14:31:00Z

7

Be sure to call SubmitChanges on your DataContext-derived class:

using(var dc = new MyDataContext())
{
    saveEmail(new Emailadressen(...));
    dc.SubmitChanges();
}

answered Feb 12, 2010 at 14:31

Anton Gogolev

116k39 gold badges204 silver badges294 bronze badges

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

1 Comment

Younes Over a year ago

Pffff, i'm a noob :). Thanks alot!

Collectives™ on Stack Overflow

Inserting data in a table with a auto increment key C# .NET Linq to SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related