[AccessD] SP to create C# classes

Charlotte Foust cfoust at infostatsystems.com
Tue Nov 13 09:30:57 CST 2007


You also use such classes to enforce business rules in the data tier
rather than having to code them into the UI.  We use such classes for
virtually all interaction with the data, bind our forms, reports and
controls to the classes, etc.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, November 13, 2007 4:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SP to create C# classes

Gustav,

The purpose should be automated building of classes from tables.  How
many times I have wished for such a thing for Access (in fact built one
myself and then lost it 8~( 

As for what to do with it... well suppose you had a table with 700 plus
fields and you wanted to do something with that table that was difficult
to do with SQL directly.  You therefore need to import the data into
classes so that you can programmatically manipulate the data...  Before
you can even begin you have to write a class with get/let and variable
dim statements in the top of the class...  How many days would it take
you to write that one class?

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, November 13, 2007 6:45 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SP to create C# classes

Hi John

Thanks!
But what should the purpose be? Building a middle-tier?

/gustav

>>> jwcolby at colbyconsulting.com 13-11-2007 11:37 >>>
I ran across this this morning.

http://www.sqlservercentral.com/scripts/Miscellaneous/31997/ 

I have not tested it yet but thought that someone might find it useful.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list