convert query to object using LINQ TO SQL

Question

I'm Working with LINQ TO SQL in C# to connect to SQL Database

and I have a table on DataBase called Person which holds information about persons and have the following fields Person_Id, First_Name,Last_Name,Email,Password

I have the following query which returns one row if there is matched :

LINQDataContext data = new LINQDataContext();
            var query = from a in data.Persons
                        where a.Email == "Any Email String"
                        select a;

my question is how to convert the query to an instance of Equivalent class which define is :

class Person
{
    public int person_id;
    public string First_Name;
    public string Last_Name;
    public string E_mail;
    public string Password;
    public Person() { }
}

how about var person = query.FirstOrDefault()?

Damith
– Damith

2013-07-15 08:58:36 +00:00
Commented Jul 15, 2013 at 8:58 — Damith
– Damith, Commented Jul 15, 2013 at 8:58

gzaxx · Accepted Answer · 2013-07-15 09:09:04Z

7

Like this:

Person query = (from a in data.Persons
            where a.Email == "Any Email String"
            select new Person { person_Id = a.Id, and so on }).FirstOrDefault();

edited Jul 15, 2013 at 9:09

answered Jul 15, 2013 at 8:53

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

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

2 Comments

Mohamad Ghanem Over a year ago

thanks for you,but I want to initialize it to a Person Type not a var and use this reference as return value for a function, how to do that ??

gzaxx Over a year ago

In my answer var will be Person (var is just a keyword to make compiler discover type by itself). You can change var to Person explicitly and it will work just fine (see my edit)

Usman Khalid · Accepted Answer · 2013-07-15 08:58:20Z

2

I will do it something like :

var query = (from a in data.Persons
            where a.Email == "Unique Email String"
            select new Person { person_Id = a.Id, etc etc });

//By using this code, you can add more conditions on query as well..

//Now the database hit will be made
var person = query.FirstOrDefault();

answered Jul 15, 2013 at 8:58

Usman Khalid

3,1209 gold badges44 silver badges68 bronze badges

Collectives™ on Stack Overflow

convert query to object 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