How to Convert the Sql Query in Linq

Question

0.00/5 (No votes)

See more:

Dear All

How to convert the following sql server query in to linq and save it in to a variable

select Name
from tblStudent
where Stid=106

Posted 25-Jun-15 11:57am

Comments

CHill60 25-Jun-15 19:08pm

Have you tried anything?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2015-06-25T15:01:00

Something like following

C#

var studName=
        from tbl in objDataContextClass.GetTable<tblstudent>()
        where tbl.Stid==106
        select tbl.Name;

You need to learn few things before you can actually implement this. Read this article
Simple LINQ to SQL in C#[^]

Hope, it helps :)

Posted 25-Jun-15 15:01pm

Updated 25-Jun-15 15:51pm

v2