StrataFrame Forum
Back
Login
Login
Home
»
Updates and Information
»
User Experiences and Testimonials
»
FillMultipleDataTables sure works !
FillMultipleDataTables sure works !
Post Reply
Like
3
FillMultipleDataTables sure works !
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Charles R Hankey
Charles R Hankey
posted 16 Years Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 524,
Visits: 30K
In my first big .NET app I have inherited the need to load at least 35 business objects with data that will be used for lookups, calculations etc.
In the appmain I have one call to one stored proc that fills all 35 business objects on one server trip (very fast) which are available as shared properties of a Lookupmanager class. Works just as advertised !
Now from anywhere in the app it is Lookupmanager.Lookups.BO.column to get a piece of data.
Very cool.
Reply
Like
3
Reply
Charles R Hankey
Charles R Hankey
posted 16 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 524,
Visits: 30K
Hi Bill
These tables are all used for lookups and for calculations used in quoting for an insurance app. Yes, all 35 tables are static, except that they are subject to authorized users changing or adding records (this will happen rarely) If I understand correctly the issue you are raising is what happens to the other users who loaded the data when they started the app and who now have old lookup data loaded. In this app the frequency of updates on this particular data set and the limited authorization to change it probably would make it acceptable that a change would take place after hours and then everyone would have the changes the next day.
But the point is a good one, and for other parts of the app, this approach definitely will not work and data will be loaded much more dynamically. I'll really give this some thought as shared properties of this kind are very new to me and I know I haven't yet thought through all the implications.
I'll post updates as I go along
Reply
Like
3
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
FillMultipleDataTables sure works !
Charles R Hankey
-
16 Years Ago
Congratulations Charles, That sounds pretty good, I have used the...
Edhy Rijo
-
16 Years Ago
Hi Charles,
Just curious...with 35 BOs, it is tough for me...
Bill Cunnien
-
16 Years Ago
Hi Bill
These tables are all used for lookups and for...
Charles R Hankey
-
16 Years Ago
Post Reply
Like
3
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search