Hello,

 

Suppose i have accouting and inventory system and they both add up to have around a 150 tables then can i define all of them in the common datalayer, how many tables can be supported in this TaskVision datalayer, since it sits in the memory, and is consistent .

Will it be ok to define individual datalayer for specific tables to make the Datalayer component more light.

 

Please advise

 

If you are going to build a system with 150 tables I suggest you use a serious datalayer (the one that comes with TaskVision
is IMHO only for little projects (less than 15 tables), you should take a look at something like NHibernate or if you are less "object oriented" the something like the Data Mapper. But I really would recommend you to try NHibernate or other real Object Relational Mapper

If you are going to build a system with 150 tables I suggest you use a serious datalayer (the one that comes with TaskVision
is IMHO only for little projects (less than 15 tables), you should take a look at something like NHibernate or if you are less "object oriented" the something like the Data Mapper. But I really would recommend you to try NHibernate or other real Object Relational Mapper