Select and insert linq query in linq

bakhtawa...

SOLVED CLOSED ACTIVE ANSWERED
User: bakhtawar
Posted: on May 12, 2016 02:10 AM
Forum: SQL Server
Answer: 1
Views: 2808

there is a table

Hide Copy Code

ID        Simno
1	+345345

What I have tried: now i want to select simno through linq query and then i insert this selected value in another table i try this i try this but how i insert this value in anther table

DataClasses1DataContext db = new DataClasses1DataContext();
db.tbl_urgent_contacts.Select(t => t.SimNo);

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on May 12, 2016 02:12 AM
Modified: on May 12, 2016 09:39 AM
Report

Hi,

Please refer below code.

If you want to fetch single record

DataClasses1DataContext db = new DataClasses1DataContext();
int simNo = db.tbl_urgent_contacts.Select(t => t.SimNo).FirstOrDefault();

If you want to fetch multiple record

DataClasses1DataContext db = new DataClasses1DataContext();
int[] simNos = db.tbl_urgent_contacts.Select(t => t.SimNo).ToArray();

I hope this will help you out.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Select and insert linq query in linq

Company

Explore

Follow us

Contact Us