how to pick id from given name in database using Linq query.

Question

1.00/5 (1 vote)

See more:

, +

hi sir,
I want to pick up ID from Given name in database Using Linq query.

DESCRIPTION:
Here i type Country ,State name in excel sheet.For bulk upload, i want to store ID in database and name shown in grid index. Here i want to using Linq query For this.And i'm using MVC 5 Repository pattern.
Kindly help me for this task.

Posted 19-Sep-14 20:31pm

JOTHI KUMAR Member 10918227

Add a Solution

Comments

Jameel VM 21-Sep-14 3:09am

did you try anything?how can we help without any code sample? you will get so many hints by searching google about linq and Repository pattern.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Suraj Sahoo | Coding Passion · Answer 1 · 2014-09-21T08:20:00

Solution 1

This solution is an anticipation from your question:-

C#

var id = Context."NAME".Where(x => x.Name == name).Select(x => x.ID);

Pass the name as parameter to the fuction. Hoping name is unique.
Thanks
:)

Posted 21-Sep-14 8:20am

Suraj Sahoo | Coding Passion

Updated 21-Sep-14 8:23am

v2

Comments

JOTHI KUMAR Member 10918227 23-Sep-14 1:46am

Where i put this function Kindly guide me sir bcz im new in mvc repository pattern

[no name] 23-Sep-14 2:47am

this should be in your repository, or the context files. Where you are doing the Database operation.

JOTHI KUMAR Member 10918227 23-Sep-14 2:56am

context

[no name] 23-Sep-14 2:58am

yes context. You must be having db operations place right!! You would be having one place where all db operations are done!! Can you place atleast your code? We will get to know from that. As you have mentioned you have used repository pattern.

JOTHI KUMAR Member 10918227 23-Sep-14 2:59am

hmm yeah i used repository also

[no name] 23-Sep-14 3:02am

yes so there you must be having the method implementation for fetching the Id from Name?? And one more thing is the Name unique !!

JOTHI KUMAR Member 10918227 23-Sep-14 3:25am

hmm yeah name is unique

[no name] 23-Sep-14 3:39am

Then please use the query I have given in the solution, and make the changes required. I am sure this wuld work out. :)

JOTHI KUMAR Member 10918227 23-Sep-14 3:45am

i will try and tell to you thanks for this ok

[no name] 23-Sep-14 3:56am

You are always welcome. Please feel free to comment if you dont get the solution.