Here is my bug from Friday. I have code something like the following that works in SQL CE 2.0:
string sql = "select field1, field2 from Table";string conStr = @"Data Source=\Stuff.sdf";SqlCeConnection con = new SqlCeConnection(conStr);con.Open();SqlCeCommand command = new SqlCeCommand(sql, con);SqlCeDataReader reader = command.ExecuteReader();SqlCeCommand updateCommand = null;StringBuilder message = new StringBuilder();while (reader.Read()){object[] vals = new object[reader.FieldCount];reader.GetValues(vals);if (null == updateCommand){//... if first record, build update commandDataTable dt = reader.GetSchemaTable();foreach (DataRow row in dt.Rows){string colName = (string)row["ColumnName"];message.Append(colName);message.Append("=");message.Append(row["ColumnSize"]);}} }
I can't find anything in the doc describing this as expected behavior, so its submitted as a bug.
Remember Me
a@href@title, strike
Powered by: newtelligence dasBlog 2.0.7226.0
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
© Copyright 2008, Damon Payne
E-mail