I switched to using my own datareader and it works so I think my suspicion 
is correct but this is not my 'preferred' solution.
(also, I have to call using a sproc, cannot do any other way to get the 
data).

            var results = new List<FormValues>();
            using(var tx = 
Session.BeginTransaction(IsolationLevel.ReadUncommitted))
            {
                using(var cmd = Session.Connection.CreateCommand())
                {
                    tx.Enlist(cmd);

                    cmd.CommandText = string.Format("Exec 
FWAPI_DTECH_Form_GetDataByDelimitedIds @FormIdList = '{0}'", formIds);

                    using(var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            results.Add(new FormValues((int)reader[0], 
(string)reader[1]));
                        }
                    }

                    tx.Commit();

                    return results;
                }
            }
        

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to