simple question about linq

[Tony Johansson]

Hello!

If I have this simple linq construction

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;

This will always give only a singe record in temp which is the result from
selct o.subfileID

If I now want to get the string value from this temp collection what is the
easiest way to do this.

Some thing like
string myID = temp.ToString();

//Tony

 

[Göran Andersson]

Hello!

If I have this simple linq construction

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;

This will always give only a singe record in temp which is the result
from selct o.subfileID

If I now want to get the string value from this temp collection what is the
easiest way to do this.

Some thing like
string myID = temp.ToString();

//Tony

That will probably give you a string with the data type...

string myID = temp.First();

or perhaps

string myID = temp[0];

 

[Tony Johansson]

Hello!

This doesn' work because you get compile error.

//Tony

Hello!

If I have this simple linq construction

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;

This will always give only a singe record in temp which is the result
from selct o.subfileID

If I now want to get the string value from this temp collection what is
the
easiest way to do this.

Some thing like
string myID = temp.ToString();

//Tony

That will probably give you a string with the data type...

string myID = temp.First();

or perhaps

string myID = temp[0];

 

[Family Tree Mike]

It should have worked fine if o.subFileID is defined as a string. You did
not say how it was defined. Perhaps: string myID = temp.First().ToString();

Hello!

This doesn' work because you get compile error.

//Tony

Hello!

If I have this simple linq construction

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;

This will always give only a singe record in temp which is the result
from selct o.subfileID

If I now want to get the string value from this temp collection what is
the
easiest way to do this.

Some thing like
string myID = temp.ToString();

//Tony

That will probably give you a string with the data type...

string myID = temp.First();

or perhaps

string myID = temp[0];

 

[Tony Johansson]

Hello!

If I use ToArray() on the temp object and then use ToString() I get the
value that
I was looking for.
string subfile = temp.ToArray()[0].ToString();

Is there an easier way or this might be one of the better ways.

//Tony

It should have worked fine if o.subFileID is defined as a string. You did
not say how it was defined. Perhaps: string myID =
temp.First().ToString();

Hello!

This doesn' work because you get compile error.

//Tony

Tony Johansson wrote:
Hello!

If I have this simple linq construction

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;

This will always give only a singe record in temp which is the result
from selct o.subfileID

If I now want to get the string value from this temp collection what
is
the
easiest way to do this.

Some thing like
string myID = temp.ToString();

//Tony

That will probably give you a string with the data type...

string myID = temp.First();

or perhaps

string myID = temp[0];

 

[Göran Andersson]

Hello!

This doesn' work because you get compile error.

//Tony

Which compiler error?

And which of the methods did you try?

 

[Göran Andersson]

Hello!

If I use ToArray() on the temp object and then use ToString() I get the
value that
I was looking for.
string subfile = temp.ToArray()[0].ToString();

Is there an easier way or this might be one of the better ways.

//Tony

What type is subFileID? Does it make sense to convert it to a string?

temp.First() returns the first item in the result, so it's type is the
same type as subFileID.

 

[Tony Johansson]

Hello!

In this linq query below we have the following types.
WorksheetList is type List<worksheet> and
type o.subFile is string.
so worksheet.subFile is a string

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;


So when I do this statement I will receive the string in subfile
string subfile = temp.ToArray()[0].ToString();

So I do think is one of the better alternatives.

//Tony

 

[Göran Andersson]

Hello!

In this linq query below we have the following types.
WorksheetList is type List<worksheet> and
type o.subFile is string.
so worksheet.subFile is a string

But what type is the field subFileID, which is the field that you use in
the query?

Or perhaps you use the wrong field in the query, and that is the main
reason that you have trouble getting the correct data from it?

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;


So when I do this statement I will receive the string in subfile
string subfile = temp.ToArray()[0].ToString();

So I do think is one of the better alternatives.

//Tony

 

[Tony Johansson]

Hello!

subFileID is a string
//Tony

Hello!

In this linq query below we have the following types.
WorksheetList is type List<worksheet> and
type o.subFile is string.
so worksheet.subFile is a string

But what type is the field subFileID, which is the field that you use in
the query?

Or perhaps you use the wrong field in the query, and that is the main
reason that you have trouble getting the correct data from it?

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;


So when I do this statement I will receive the string in subfile
string subfile = temp.ToArray()[0].ToString();

So I do think is one of the better alternatives.

//Tony

Tony Johansson wrote:
Hello!

This doesn' work because you get compile error.

//Tony


Which compiler error?

And which of the methods did you try?

 

[Göran Andersson]

Hello!

subFileID is a string
//Tony

In that case you should only need:

string subfile = temp.First();

There is no reason to use the ToString method on a string.

Hello!

In this linq query below we have the following types.
WorksheetList is type List<worksheet> and
type o.subFile is string.
so worksheet.subFile is a string

But what type is the field subFileID, which is the field that you use
in the query?

Or perhaps you use the wrong field in the query, and that is the main
reason that you have trouble getting the correct data from it?

var temp = from o in myWorksheetList
where o.ID == workSheetID
select o.subFileID;


So when I do this statement I will receive the string in subfile
string subfile = temp.ToArray()[0].ToString();

So I do think is one of the better alternatives.

//Tony


Tony Johansson wrote:
Hello!

This doesn' work because you get compile error.

//Tony


Which compiler error?

And which of the methods did you try?