Advertisement

06.13.2008 at 10:57AM PDT, ID: 23483556
[x]
Attachment Details

Combining LINQ to SQL with Inline SQL

Asked by used2could in Language Integrated Query - LINQ, Microsoft Visual Basic.Net, Microsoft Visual C#.Net

Tags: C#, LINQ

I am converting a project that i am in the process of developing to use LINQ to SQL. My problem is a scheduled process that syncs data with a 3rd party via several XML files. I am building one huge sql script to run at the end of the xml parsing process  to then execute in one trip to the database. A big part of this is a series of SQL "if" statements to see if something exists with some conditional logic and either update or insert a new record. From what i know LINQ doesn't handle conditional update or inserting without multiple database trips. I want to be able to get the generated SQL (select/insert/update/delete) using LINQ (without a trip to the DB) then mix it in with my own SQL for the conditional decision of insert or update. How do i get the generated SQL from LINQ for a select, insert, update or delete ?

Thanks
~B
Start Free Trial
[+][-]06.13.2008 at 01:06PM PDT, ID: 21782356

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 01:31PM PDT, ID: 21782534

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 06:02PM PDT, ID: 21783641

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Language Integrated Query - LINQ, Microsoft Visual Basic.Net, Microsoft Visual C#.Net
Tags: C#, LINQ
Sign Up Now!
Solution Provided By: CarlVerret
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.14.2008 at 08:25AM PDT, ID: 21785662

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.15.2008 at 12:22AM PDT, ID: 21787774

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628