Deserialize a database table row straight into a C# object - is there a mechanism for this?
<p>I am new to C# and this may end up being a dumb question but i need to ask anyway.</p>

<p>Is there a mechanism with C# to deserialize a result from an executed SQL statement into a c# object?</p>

<p>I have a C# program that reads a table from an sql server storing the row in an object - i am assigning each column value to an object member manually so i was wondering if there is a way to serialize the row automagically into an object. Or even better, a whole table in a collection of objects of the same type.</p>

<p>My environment is C#, VS2010, .NET4, SQLServer2008. 
The assumption is that i know the columns i need, it's not a select * query.</p>

<p>A link to a neat example will also be appreciated.</p>

<p>Thanks.</p>
