Hi Michel,

Thanks, I was not aware this was causing a problem. Given what you have found, it is probably best not to use the DBPortal.GetTableFromDataReader method, I changed my code like this:

DataTable dt = new DataTable();
            dt.Columns.Add("ModuleID", typeof(int));
            dt.Columns.Add("ModuleGuid", typeof(string));
            dt.Columns.Add("SettingName", typeof(string));
            dt.Columns.Add("SettingValue", typeof(string));
            dt.Columns.Add("ControlType", typeof(string));
            dt.Columns.Add("ControlSrc", typeof(string));
            dt.Columns.Add("HelpKey", typeof(string));
            dt.Columns.Add("SortOrder", typeof(int));
            dt.Columns.Add("RegexValidationExpression", typeof(string));

            using (IDataReader reader = SqliteHelper.ExecuteReader(
                GetConnectionString(),
                sqlCommand.ToString(),
                arParams))
            {
                while (reader.Read())
                {
                    DataRow row = dt.NewRow();
                    row["ModuleID"] = reader["ModuleID"];
                    row["ModuleGuid"] = reader["ModuleGuid"];
                    row["SettingName"] = reader["SettingName"];
                    row["SettingValue"] = reader["SettingValue"];
                    row["ControlType"] = reader["ControlType"];
                    row["ControlSrc"] = reader["ControlSrc"];
                    row["HelpKey"] = reader["HelpKey"];
                    row["SortOrder"] = reader["SortOrder"];
                    row["RegexValidationExpression"] = reader["RegexValidationExpression"];

                    dt.Rows.Add(row);

                }

            }

            return dt;

Best,

Joe

Hi Michel,

After making this change I realized I could have fixed it just as easily from inside the DBPortal.cs GetTableFromReader method by commenting out the line that sets if it is unique like this:

// we don't always want to enforce constraints, it may be fine to have duplicates in a query even if the underlying table has a unique constraint
//column.Unique = Convert.ToBoolean(schemaTable.Rows[i]["IsUnique"]);

We really don't need the constraints, the only reason we are using a DataTable is if we want to be able to loop through the data more than once or if we are going to be calling other data methods while looping over them then we don't want to have an IDataReader which has an open connection while we do that.

Best,

Joe