converting VB linq to c# linq

Question

I am trying to convert link query in vb below to C#. I have never previously done vb and linq query before, I have converted to SQL but what would this be in linq c#,

VB script

 Dim d = (From p In db.tblkeyPages Join keypagetype In db.tblkeyPageTypes On p.keyPageType Equals keypagetype.keyPageType Where keypagetype.keyPageType = 1 Select p.pageContent).First

SQL

select d.keyPageType, d.pageContent from dbo.tblkeyPage as d
join (select keyPageType from dbo.tblkeyPageType )as s 
on d.keyPageType = s.keyPageType
where s.keyPageType = 1

Do you have any progress on converting to C#?

Sergey Berezovskiy
– Sergey Berezovskiy

2013-12-10 16:55:32 +00:00
Commented Dec 10, 2013 at 16:55 — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Dec 10, 2013 at 16:55
@X.L.Ant: You should try this first.

Dave Doknjas
– Dave Doknjas

2013-12-10 18:52:06 +00:00
Commented Dec 10, 2013 at 18:52 — Dave Doknjas
– Dave Doknjas, Commented Dec 10, 2013 at 18:52

Sergey Berezovskiy · Accepted Answer · 2013-12-10 16:56:50Z

2

Here is good starting point: Introduction to LINQ Queries (C#)

var content = (from p in db.tblkeyPages 
               join keypagetype in db.tblkeyPageTypes 
                    on p.keyPageType equals keypagetype.keyPageType
               where keypagetype.keyPageType == 1
               select p.pageContent).First();

Also I suggest you to spend time learning C# syntax. As you can see, query looks almost same (just keywords are lower case, because C# is a case-sensitive language)

One more note - if you want to avoid exception, then use FirstOrDefault() instead of First() when it is possible that no results will be returned by query.

answered Dec 10, 2013 at 16:56

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3086751 Over a year ago

Thanks for the help.. that link really helped in link query.

Collectives™ on Stack Overflow

converting VB linq to c# linq

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related