LINQ to SQL - Get a string from a Var

Question

I'm new to LINQ to SQL world - So I'm sorry if the question is stupid :) - I just could not find any answer on the internet:

I have a table with two columns - "Batch_Name" and "Batch_id". The user select the batch id and the application needs to return its name.

I have this C# Code to extract the batch name according to the batch id ("myBatchNum"):

        var thisBatch = from x in gridDB.batches
                        where x.batch_id == myBatchNum
                        select new { x.batch_name };


        lblBatchName.Text = thisBatch.First().ToString();

This extract from the proper batch name, but when I try to display the name on a label control, I get this result ("NightBatch is the name in the DB):

{batch_name = NightBatch }

How do I extract the batch name from "thisBatch" properly to the label control?

Thank you so much, Nim.

Jon Skeet · Accepted Answer · 2011-06-21 09:30:19Z

3

It's unclear that you need to use an anonymous type at all. Just use:

var thisBatch = from x in gridDB.batches
                where x.batch_id == myBatchNum
                select x.batch_name;

lblBatchName.Text = thisBatch.First();

Or if you did want to use an anonymous type still, just use the property you've effectively created:

var thisBatch = from x in gridDB.batches
                where x.batch_id == myBatchNum
                select new { x.batch_name };

lblBatchName.Text = thisBatch.First().batch_name;

answered Jun 21, 2011 at 9:30

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Comments

thekip · Accepted Answer · 2011-06-21 09:31:02Z

1

Remove the ToString() at the end as you already select only the name

answered Jun 21, 2011 at 9:31

thekip

3,7582 gold badges24 silver badges42 bronze badges

Comments

Coding Flow · Accepted Answer · 2011-06-21 09:31:14Z

1

You are creating an anonymous type with one property called batch_name. Chage your code as below to return strings:

var thisBatch = from x in gridDB.batches
                where x.batch_id == myBatchNum
                select x.batch_name;

answered Jun 21, 2011 at 9:31

Coding Flow

21.9k6 gold badges68 silver badges84 bronze badges

Comments

Tim Rogers · Accepted Answer · 2011-06-21 09:31:17Z

0

You are calling ToString() on the anonymous type you've generated in the select statement. Try this:

lblBatchName.Text = thisBatch.First().batch_name;

answered Jun 21, 2011 at 9:31

Tim Rogers

21.8k8 gold badges55 silver badges69 bronze badges

Collectives™ on Stack Overflow

LINQ to SQL - Get a string from a Var

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related