[DotNetDevelopment] Linq bulk update/insert

[Koby]

Hi, I have recently developed a C# application using Linq. I am
getting from an external database a list of profiles I need to
process, some are new and some are already in the database, and need
to be updated. What I do today is go over the profile list and check
each profile if such exists I update otherwise I insert - this
solution is working fine.

I am sure there is a way to use bulk insert/update something like
UPDATE ON DUPLICATE, this way I can save time since the files I get
are huge and bulk insert/update is known to have better performance. I
would like to avoid the iteration I am now using.

insertall doesn't work for already stored rows, I need the combination
of both update and insert

Here is my code, Your help is highly appreciated.

foreach (Profile tmpProfile in profiles)
            {
                try
                {
                    var matchedProfile = (from c in db.ProfileEntities
                                          where c.ProfileId ==
tmpProfile.Id
                                          select c).SingleOrDefault();

                    if (matchedProfile == null)
                    {
                        //Insert
                        db.ProfileEntities.InsertOnSubmit
(EntityMapper.ToEntity(tmpProfile));

                    }
                    else
                    {
                        //Update
                        EntityMapper.ToEntity(ref matchedProfile,
tmpProfile);

                    }
                }
                catch (System.Data.SqlServerCe.SqlCeException sqlExec)
                {

                }
                catch (Exception e)
                {

                }
            }

            db.SubmitChanges();