forum

Home / DeveloperSection / Forums / Linq Query for dataset in c#?

Linq Query for dataset in c#?

Anonymous User 2785 04-Feb-2014

I have dataset which contains two table as

DataTable dtFields = new DataTable("tmpFieldTable");
            dtFields.Columns.Add("FieldID");
            dtFields.Columns.Add("CDGroupID");
            dtFields.Columns.Add("CDCaption");
            dtFields.Columns.Add("fldIndex");
DataTable dtCDGroup = new DataTable("tmpCDGroup");
            dtCDGroup.Columns.Add("CDGroupID");
            dtCDGroup.Columns.Add("Name");
            dtCDGroup.Columns.Add("Priority");
DataSet ds = new DataSet("tmpFieldSet");
            ds.Tables.Add(dtFields);
            ds.Tables.Add(dtCDGroup);

How can I write following SQL quey to LINQ

queryString = "Select FieldID, tmpCDGroup.Name, CDCaption, IIF(ISNULL(Priority),99,Priority), fldIndex from tmpFieldList LEFT OUTER JOIN tmpCDGroup ON tmpFieldList.CDGroupID = tmpCDGroup.CDGroupID order by 4,5 ";


c# c# 
Updated on 04-Feb-2014
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By