Monthly Archives: October 2012

ADO.NET Insert or Update

Posted on 23/10/2012 by Paul Fox

This bit of code is great for inserting a record if it does not exist or update the one that does exist in the table.

            var exists = (from r in db.tAXBusRelStatus
                          where r.BusRelAccount.Equals(_BusRelNo)
                          select r).FirstOrDefault();

                // Now check to see if the record exists
                if (exists == null)
                { // Do a insert
                    tAXBusRelStatu newRecord = new tAXBusRelStatu() { BusRelAccount = _BusRelNo, BusRelStatus = _Status };
                    db.AddTotAXBusRelStatus(newRecord);
                }
                else
                { // Do a update
                    exists.BusRelStatus = _Status;
                }
                db.SaveChanges();

var exists = (from r in db.tAXBusRelStatus

where r.BusRelAccount.Equals(_BusRelNo)

select r).FirstOrDefault();

// Now check to see if the record exists

if (exists == null)

{ // Do a insert

tAXBusRelStatu newRecord = new tAXBusRelStatu() { BusRelAccount = _BusRelNo, BusRelStatus = _Status };

db.AddTotAXBusRelStatus(newRecord);

}

else

{ // Do a update

exists.BusRelStatus = _Status;

}

db.SaveChanges();

Posted in C# Development | Comments Off