Storing LINQ Query object to an Integer

Question

I have a LINQ2SQL Query:

 //Pulling the Product_ID from the PlanMaster Table from WebEnroll DB!
                var tr = from s in dt.PlanMasters
                         where s.PlanName == productName
                         select new
                         {
                             s.Product_ID
                         };

This is pulling Product_ID which is working good. Now I want to ADD a record into another LINQ statement which is here:

                CommissionsV2DataContext cv = new CommissionsV2DataContext();
                Entity_Product_Point ev = new Entity_Product_Point();
                ev.Entity_ID = getEntity;
                ev.Product_ID = tr.; ?????

I want to store the variable which I am getting from tr (that is Product_ID) to ev.Product_ID.

How should I convert an object to an INT? Thank you!

Jacob · Accepted Answer · 2011-04-06 18:42:37Z

5

The problem is that your first query returns a collection of objects with an integer property, not a single integer. You can change your query to this instead:

var tr = (
    from s in dt.PlanMasters
    where s.PlanName == productName
    select s.Product_ID).First();

Or, more cleanly, IMO:

var tr = dt.PlanMasters.First(s => s.PlanName == productName).Product_ID;

answered Apr 6, 2011 at 18:42

Jacob

79k24 gold badges159 silver badges245 bronze badges

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

2 Comments

Matt Greer Over a year ago

I believe the second one still needs to call Select

Jacob Over a year ago

Nope. First can take a delegate so that the first record that evaluates to true is returned.

rsenna · Accepted Answer · 2011-04-06 18:42:58Z

3

tr is a collection. You have to call tr.FirstOrDefault().Product_ID.

edited Apr 6, 2011 at 18:42

rsenna

12.1k1 gold badge58 silver badges62 bronze badges

answered Apr 6, 2011 at 18:40

Daniel A. White

192k49 gold badges389 silver badges473 bronze badges

Comments

Adam Price · Accepted Answer · 2011-04-06 18:40:40Z

1

I would change your linq query to select just the s.Product_ID instead of select newing a new anonymous object containing the ID.

 var tr = from s in dt.PlanMasters
          where s.PlanName == productName
          select s.Product_ID;

Your second code block could then be simply ev.Product_ID = tr.First();

  CommissionsV2DataContext cv = new CommissionsV2DataContext();
  Entity_Product_Point ev = new Entity_Product_Point();
  ev.Entity_ID = getEntity;
  ev.Product_ID = tr.First();

answered Apr 6, 2011 at 18:40

Adam Price

10.3k1 gold badge22 silver badges16 bronze badges

3 Comments

BrokenGlass Over a year ago

this won't work - tr is an IQueryable and not a number - you'll have to use i.e. tr.Single() assuming there is only one - otherwise the query is flawed.

Adam Price Over a year ago

or tr.First()... which is used.

BrokenGlass Over a year ago

Guess I hadn't refreshed the page - it wasn't there in the first version

tnx247 · Accepted Answer · 2011-04-06 18:43:26Z

0

ev.Product_ID = tr.First().Product_ID;

answered Apr 6, 2011 at 18:43

tnx247

1,2181 gold badge11 silver badges23 bronze badges

Collectives™ on Stack Overflow

Storing LINQ Query object to an Integer

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related