<div>
HI!<br />
<br />
You can try this as well<br />
<br />
if (reader.GetSchemaTable().C<wbr />olumns[&quot;CO<wbr />LUMNNAME&quot;]<wbr /> != null)<br />
<br />
<br />
Thanks!<br />
<br />

</div>


<div>
This isn't quite right is it - the SchemaTable returned is a table about the resultset, and the columns are ColumnName, ColumnOrdinal, ColumnSize etc, so it will only tell me about the columns in the schema table, not the columns in the resultset.<br />
<br />
If for example I want to know if a column called &quot;Sequence&quot; is in my result set, <br />
<br />
if (reader.GetSchemaTable().C<wbr />olumns[&quot;Se<wbr />quence&quot;] != null)<br />
<br />
won't do it.
</div>


<div>
That's pretty clever - I'll wait a little longer if you don't mind just to see if anyone comes up with anything as good...
</div>


<div>
Sorry - I didn't actually intend to wait quite so long..
</div>


<div>
<div class="content wysiwyg-content">
The only way to check if a column exists in a SqlDataReader is by looping through the columns<br />
<br />
<a href="http://stackoverflow.com/questions/373230/check-for-column-name-in-a-sqldatareader-object" rel="ugc">http://stackoverflow.com/questions/373230/check-for-column-name-in-a-sqldatareader-object</a><br />
<br />
can anyone give me some linq to do this so I can put the check in a single statement?
</div>
</div>


The only way to check if a column exists in a SqlDataReader is by looping through the columns

http://stackoverflow.com/questions/373230/check-for-column-name-in-a-sqldatareader-object

can anyone give me some linq to do this so I can put the check in a single statement?

Check column exists in SqlReader using Linq

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.