• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8106
  • Last Modified:

if record exists update else insert using LINQ

I have an xml file that I parse and insert into the database. What I want to do is, if the records in the xml file already exist in the database I just want to update the database, If they don't exist I would like to insert them. I would like to do this as efficiently as possible either through LINQ and/or stored procedures, but can't find anything online. The xml file has IDs that correspond to database IDs.

Running ASP.NET 3.5 and MS Server 08

Thanks
0
idsnews
Asked:
idsnews
  • 2
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you use SQL 2008, you should learn up the newly introduce MERGE statement:
http://www.builderau.com.au/program/sqlserver/soa/Using-SQL-Server-2008-s-MERGE-statement/0,339028455,339283059,00.htm
0
 
idsnewsAuthor Commented:
Thanks, but from the looks of it the MERGE statement is only useful for merging tables. Whereas I need to merge a table with an XML document.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
with SQL Server, using XML means using OPENXML() function to get a table-valued output from XML input.
as from SQL 2005, you could also use the xml data type, and perform XQuery on that to again have "table" data.

once you have that, the MERGE can be brought into play ...
0
 
naspinskiCommented:
If you want to use linq:
//instead of this foreach<int> you will do a foreach<XElement> or something else to run through your xml entries
//Also, you will obviously have to change my item class to what you want
foreach (int xmlID in xmlEntries)
{
    try
    {
        item i = (from p in db.items where p.itemID == xmlID select p).First();
        //it is present in the database -- now edit it
    }
    catch
    { 
        //it wasn't there, so insert it
    }

Open in new window

0
 
idsnewsAuthor Commented:
Thanks angelll for the MERGE solution but it seekemed a little over my head and the try catch with the LINQ was exactly what I was looking for because I was already parsing the XML file using linq and XElements
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now