public void ViewState () { SqlPoker sql = new SqlPoker (); sql.CacheKeyDependency = "hi"; sql.CancelSelectOnNullParameter = false; sql.ConflictDetection = ConflictOptions.CompareAllValues; sql.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure; sql.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sql.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure; sql.OldValuesParameterFormatString = "{1}"; sql.SqlCacheDependency = "hi"; sql.SortParameterName = "hi"; sql.CacheDuration = 1; sql.CacheExpirationPolicy = DataSourceCacheExpiry.Sliding; sql.EnableCaching = true; sql.DataSourceMode = SqlDataSourceMode.DataReader; sql.DeleteCommand = "DELETE foo"; sql.InsertCommand = "INSERT foo"; sql.SelectCommand = "SELECT foo"; sql.UpdateCommand = "UPDATE foo"; sql.FilterExpression = "hi"; Assert.AreEqual ("hi", sql.CacheKeyDependency, "A1"); Assert.IsFalse (sql.CancelSelectOnNullParameter, "A2"); Assert.AreEqual (ConflictOptions.CompareAllValues, sql.ConflictDetection, "A3"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.DeleteCommandType, "A4"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.InsertCommandType, "A5"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.SelectCommandType, "A6"); Assert.AreEqual (SqlDataSourceCommandType.StoredProcedure, sql.UpdateCommandType, "A7"); Assert.AreEqual ("{1}", sql.OldValuesParameterFormatString, "A8"); Assert.AreEqual ("hi", sql.SqlCacheDependency, "A9"); Assert.AreEqual ("hi", sql.SortParameterName, "A10"); Assert.AreEqual (1, sql.CacheDuration, "A11"); Assert.AreEqual (DataSourceCacheExpiry.Sliding, sql.CacheExpirationPolicy, "A12"); Assert.IsTrue (sql.EnableCaching, "A13"); Assert.AreEqual (SqlDataSourceMode.DataReader, sql.DataSourceMode, "A16"); Assert.AreEqual ("DELETE foo", sql.DeleteCommand, "A17"); Assert.AreEqual ("INSERT foo", sql.InsertCommand, "A20"); Assert.AreEqual ("SELECT foo", sql.SelectCommand, "A22"); Assert.AreEqual ("UPDATE foo", sql.UpdateCommand, "A24"); Assert.AreEqual ("hi", sql.FilterExpression, "A26"); object state = sql.SaveToViewState (); Assert.IsNull (state, "ViewState is null"); sql = new SqlPoker (); sql.LoadFromViewState (state); Assert.AreEqual ("", sql.CacheKeyDependency, "B1"); Assert.IsTrue (sql.CancelSelectOnNullParameter, "B2"); Assert.AreEqual (ConflictOptions.OverwriteChanges, sql.ConflictDetection, "B3"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.DeleteCommandType, "B4"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.InsertCommandType, "B5"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.SelectCommandType, "B6"); Assert.AreEqual (SqlDataSourceCommandType.Text, sql.UpdateCommandType, "B7"); Assert.AreEqual ("{0}", sql.OldValuesParameterFormatString, "B8"); Assert.AreEqual ("", sql.SqlCacheDependency, "B9"); Assert.AreEqual ("", sql.SortParameterName, "B10"); Assert.AreEqual (0, sql.CacheDuration, "B11"); Assert.AreEqual (DataSourceCacheExpiry.Absolute, sql.CacheExpirationPolicy, "B12"); Assert.IsFalse (sql.EnableCaching, "B13"); Assert.AreEqual (SqlDataSourceMode.DataSet, sql.DataSourceMode, "B16"); Assert.AreEqual ("", sql.DeleteCommand, "B17"); Assert.IsNotNull (sql.DeleteParameters, "B18"); Assert.AreEqual (0, sql.DeleteParameters.Count, "B18.1"); Assert.IsNotNull (sql.FilterParameters, "B19"); Assert.AreEqual (0, sql.FilterParameters.Count, "B19.1"); Assert.AreEqual ("", sql.InsertCommand, "B20"); Assert.IsNotNull (sql.InsertParameters, "B21"); Assert.AreEqual (0, sql.InsertParameters.Count, "B21.1"); Assert.AreEqual ("", sql.SelectCommand, "B22"); Assert.IsNotNull (sql.SelectParameters, "B23"); Assert.AreEqual (0, sql.SelectParameters.Count, "B23.1"); Assert.AreEqual ("", sql.UpdateCommand, "B24"); Assert.IsNotNull (sql.UpdateParameters, "B25"); Assert.AreEqual (0, sql.UpdateParameters.Count, "B25.1"); Assert.AreEqual ("", sql.FilterExpression, "B26"); }