linq to sql (VS 2010) - insert doesn't work

I have a class containing my data context:

private static drDataContext db = new drDataContext();

I also have the method:

public static void InsertSelfRatings(List<DeveloperSelfRating> ratings)
    {

        foreach (DeveloperSelfRating sr in ratings)
        {
            db.DeveloperSelfRatings.InsertOnSubmit(sr)开发者_运维百科;
        }

        // db.DeveloperSelfRatings.InsertAllOnSubmit(ratings);

        db.SubmitChanges();
    }

I tried both InsertOnSubmit() and InsertAllOnSubmit() and I encounter the same problem - only the last record (DeveloperSelfRating object) in the 'ratings' list is being inserted into the database.

What might be the reason for this problem?

Thanks !!!

---

You just put this line db.SubmitChanges(); in foreach loop like

public static void InsertSelfRatings(List ratings)

{

    foreach (DeveloperSelfRating sr in ratings)
    {
        db.DeveloperSelfRatings.InsertOnSubmit(sr);
        db.SubmitChanges();

    }



}

Because when u insert one record in linq you have to do submit changes so after every insert you have to write db.SubmitChanges(); just try this ok