retrieve data and write it to a hashtable

antoschka · **Joined:** Tue Jan 22, 2008 11:33 am **Posts:** 46

I would like to retrieve data form a table and write Values to a hashtable

Code:

public class MyClass
{
static Hashtable myHash;

static MyClass()
{
Configuration cfg = new Configuration();
            cfg.AddAssembly("...");
            ISessionFactory factory = cfg.BuildSessionFactory();
            ISession session = factory.OpenSession();
            ITransaction transaction = session.BeginTransaction();
            
            IList results = session.CreateCriteria(typeof(ProductType)).List();

foreach (ProductType myProduct in results)
            {    
myHash.Add(myProduct.TypeName,  myProduct.TypeId);
            }
}
}

the List() Method retrieves all data. But it comes to myHash.Add it always throws an exception "Creating a proxy instance failed". The debugger jumps to code which caused to constructor call of MyClass.

Any idea how I can retrieve all rows of a table and write the name and id column (both are strings) of each row to a hashtable or Enum?

Thanks antoschka

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

I would assume that anything dealing with persistable classes has to live on a class instance. Try using a non-static HashTable.

Matrasinator · **Joined:** Fri Aug 10, 2007 3:34 am **Posts:** 44

you could also try to make a hashtable collection to your class and map it
then you would trully persist the data to a hashtable
(what you did there is just filling a hashtable...)

antoschka · **Joined:** Tue Jan 22, 2008 11:33 am **Posts:** 46

Sounds good, but how exactly can I do that?

Thanks in advance

antoschka

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

I your collection of children is anything but a Set, you can still persist it, but through the interface UserCollectionType.