Search SQL db using LINQ to SQL

Question

I am trying to search DB using LINQ to SQL and display it. I tried below code but it not showing record matching to criteria on console.

Here Details is table name

Detail detail = new Detail();

    Console.Write("\nEnter ID to Search Record :");
     int id = Convert.ToInt32(Console.ReadLine());
     var searchbyId = from search in db.Details
                         where search.Id == id
                         select search;
     db.SubmitChanges();
     Console.WriteLine("\n Search Results \n");
     Console.WriteLine(String.Format("Id \t | Name \t | Last Name \n"));

     Console.WriteLine(String.Format("{0} \t | {1} \t | {2} ",
                               detail.Id,detail.Name, detail.LastName));

Newbie trying to learn LINQ

What's detail here?

Rahul Singh
– Rahul Singh

2015-01-19 06:56:32 +00:00
Commented Jan 19, 2015 at 6:56 — Rahul Singh
– Rahul Singh, Commented Jan 19, 2015 at 6:56
Why a SubmitChanges ? You don't update anything in db.

Eric Bole-Feysot
– Eric Bole-Feysot

2015-01-19 06:57:02 +00:00
Commented Jan 19, 2015 at 6:57 — Eric Bole-Feysot
– Eric Bole-Feysot, Commented Jan 19, 2015 at 6:57
what's up with db.SubmitChanges();?

rasso
– rasso

2015-01-19 06:57:37 +00:00
Commented Jan 19, 2015 at 6:57 — rasso
– rasso, Commented Jan 19, 2015 at 6:57
you never used searchbyId object aftre assign the value

HaveNoDisplayName
– HaveNoDisplayName

2015-01-19 06:57:51 +00:00
Commented Jan 19, 2015 at 6:57 — HaveNoDisplayName
– HaveNoDisplayName, Commented Jan 19, 2015 at 6:57
Just a newbie trying to learn LINQ

Richa
– Richa

2015-01-19 06:58:03 +00:00
Commented Jan 19, 2015 at 6:58 — Richa
– Richa, Commented Jan 19, 2015 at 6:58

Dgan · Accepted Answer · 2015-01-19 06:59:58Z

2

There may be Multiple Results having Same ID so Use foreach

Console.Write("\nEnter ID to Search Record :");
 int id = Convert.ToInt32(Console.ReadLine());
 var searchbyId = from search in db.Details
                     where search.Id == id
                     select search;

 Console.WriteLine("\n Search Results \n");
 Console.WriteLine(String.Format("Id \t | Name \t | Last Name \n"));

 foreach(var item in searchbyId )
 Console.WriteLine(String.Format("{0} \t | {1} \t | {2} ",
                           item.Id,detail.Name, item.LastName));

101 LINQ Samples

answered Jan 19, 2015 at 6:59

Dgan

10.3k1 gold badge33 silver badges51 bronze badges

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

2 Comments

Richa Over a year ago

Thanks a lot. It worked perfectly. Will accept it as answer soon

Dgan Over a year ago

@Richa try 101 LINQ Samples those are best from MSDN

Eric Bole-Feysot · Accepted Answer · 2015-01-19 07:06:50Z

0

I would try something like that:

Console.Write("\nEnter First Name :");
string id = Convert.ToInt32(Console.ReadLine());
var searchbyId = from search in db.Details
                 where search.Id == id
                 select search;
Console.WriteLine("\n Search Results \n");
Console.WriteLine(String.Format("Id \t | Name \t | Last Name \n"));

foreach(var item in searchbyId )
Console.WriteLine(String.Format("{0} \t | {1} \t | {2} ",
                       searchbyId.Id,detail.Name, searchbyId.LastName));

edited Jan 19, 2015 at 7:06

answered Jan 19, 2015 at 6:59

Eric Bole-Feysot

15.5k7 gold badges51 silver badges53 bronze badges

Collectives™ on Stack Overflow

Search SQL db using LINQ to SQL

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related