Linq Query for dataset in c#?

Anonymous User 3436 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 ";

Ask by Anonymous User

Updated 04 Feb 2014

1 Answers

Pravesh Singh 04 Feb 2014

Hi Tanuj,

var resultArray = tmpFieldList.Join(
    tmpCDGroup,  // inner join
collection
    fieldList =>fieldList.CDGroupID,  // outer key
selector  cd =>cd.CDGroupID,      // inner
key selector    (fieldList, cd)
=> new {            // result
selector
        FieldID =fieldList.FieldID,
         Name =cd.Name,
         CDCaption =cd.CDCaption,
         Priority =fieldList.Priority ?? 99,
         fldIndex =fieldList.fldIndex
     }).OrderBy(result => result.Priority)


.ThenBy(result => result.fldIndex)


.ToArray();

Then you can access using, for example,

resultArray[0].FieldID

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Linq Query for dataset in c#?

Can you answer this question?

1 Answers