Is there any way that I can get my .NET classes automatically generated from the Tables in Access. Anything like ORM available? thx in adv
A:
NHibernate is supported on Microsoft Access: http://www.hibernate.org/
LINQ to SQL and Entity Framework do not support Access.
Ray Booysen
2009-01-04 15:47:39
I didn't think Entity Framework cared what the DB was? Or is this a designer issue?
AnthonyWJones
2009-01-04 15:50:13
A:
MyGeneration got some Templates for Automatically generate Classes from Access Tables.
Yoann. B
2009-01-04 15:48:40
At least with NHibernate you've got the support knowing that this is a product that is tried and tested.
Ray Booysen
2009-01-04 15:50:45
Yes, but you can use both MyGeneration and NHibernate to generated hbm xml files and classes :)
Yoann. B
2009-01-04 15:54:35
+1
A:
You can either use an ORM such as nHibernate, here's a partial older list of ORM's http://www.theserverside.net/news/thread.tss?thread_id=29914
Or you could use code generation techniques, such as CodeSmith http://www.codesmithtools.com/
JoshBerke
2009-01-04 15:58:46
A:
You can add a DataSet to your project (Add New Item) and then drag-and-drop your tables onto the dataset-view. This will automatically generate classes for the tables.
Ville Krumlinde
2009-01-04 16:37:05