Entity Framework 4.0 - Reading Values From SQL Table

Question

1.00/5 (1 vote)

See more:

Hi all,

I am new with using Entity Framework 4.0. I need
to simply read a single column from a SQL Table.

Can anyone please tell me how to do this?

Posted 25-Jun-12 3:21am

Ben Paxton

Add a Solution

Comments

Zoltán Zörgő 25-Jun-12 9:30am

So: you have a table with several fields but you want to map only one of them? You never use the other fields in your application - why have you them? You can map all fields to the class, and use LINQ to retrieve the desired field.

2 solutions

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)

Libish Varghese Jacob · Answer 1 · 2012-06-25T23:24:00

Solution 1

Go through this. this should help you.

How to configure and use Entity Framework[^]

Posted 25-Jun-12 23:24pm

Libish Varghese Jacob

Rahul Rajat Singh · Answer 2 · 2012-06-25T23:55:00

Solution 2

You could find this article useful. This article shows how to perform basic CRUD operations using Entity framework. You might have to use some LINQ to specify the specific column you need and you will get what you want.

An Introduction to Entity Framework for Absolute Beginners[^]

Posted 25-Jun-12 23:55pm

Rahul Rajat Singh