C# : Make Dataset Serializable for use in SessiosnState Mode SqlServer
<p>We have web based application, we used dataset to store the information. WE used to store these datasets in Sessions and get from Sessions during Ajax call and update them.
At that time Session State was InProc.</p>

<p>Now We want to store the session data in Sql Sever, to store in session we need to make the dataset [Serializable]</p>

<p>I test with normal datasets it works fine, but in our case we create our DataSets by inherit from DataSet like</p>

<pre><code>public class OurDataSet : DataSet
{
#constants
all the column names are used in all the tables are used as Constants.

#constructor
// add all the related tables
public OurDataSet()
{
this.Tables.Add(OurDataTable());
}
public static DataTable OurDataTable()
{
}
}
</code></pre>

<p>My problem is that i can not serialized this object even decorated with [Serializable] attribute.</p>

<ol>
<li>How i will be able to store this dataset in the SQLServer session mode and get it back.</li>
<li>It serialize fine, but gives me the following error on getting the data back from sqlserver.
The constructor to deserialize an object of type 'OurDataSet' was not found.</li>
</ol>

<p>Thanks</p>
