Hi,

using VB.NET i have the following design / implementation issue.

We're designing an insurance underwriting project, which i describe a bit in
english

For every insurance policy there could be an undetermined number of
properties to the policy (for example property investors etc).

my question is what would be the best way to store these in memory before
commiting them to the database while performing business logic.

My question is what would be best for editing entries? List(of t) or
datatable?

Many thanks for your help

Simon

"Simon Whale" <(E-Mail Removed)> wrote in news:OO6kRmGaKHA.5300
@TK2MSFTNGP02.phx.gbl:

> My question is what would be best for editing entries? List(of t) or
> datatable?

The list is lighter weight, so, if it is prudent, I would head that
direction. But, there are factors that may make the list an issue.

For example, if the list is rarely edited before committing, then making
editing easier is not your primary concern. The primary concern is
reducing errors on saving and using the most maintainable code possible.
In this instance, the DataTable might be better, especially if you use
TableAdapters to commit data.

What you have to look at is the most common path combined with
maintainability. That is first run. Then, see if there are any other
issues , like performance, that makes you rethink your chosen path.

One more thing to think of. If you are using the built in CRUD
methdology with DataSets, you end up with a translation "layer" for your
entries to turn them into a List(of T) and back. This is one potential
source of error. I am not saying avoid this, but ask your motivation
before you introduce this extra "complexity" into the app.

Peace and Grace,
Greg

--
Vote for Miranda's Christmas Story
http://tinyurl.com/mirandabelieve

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

Thanks Gregory

it gives me some food for thought!

Simon

"Gregory A. Beamer" <(E-Mail Removed)> wrote in message
news:Xns9CC76E727E338gbworld@207.46.248.16...
> "Simon Whale" <(E-Mail Removed)> wrote in news:OO6kRmGaKHA.5300
> @TK2MSFTNGP02.phx.gbl:
>
>> My question is what would be best for editing entries? List(of t) or
>> datatable?
>
> The list is lighter weight, so, if it is prudent, I would head that
> direction. But, there are factors that may make the list an issue.
>
> For example, if the list is rarely edited before committing, then making
> editing easier is not your primary concern. The primary concern is
> reducing errors on saving and using the most maintainable code possible.
> In this instance, the DataTable might be better, especially if you use
> TableAdapters to commit data.
>
> What you have to look at is the most common path combined with
> maintainability. That is first run. Then, see if there are any other
> issues , like performance, that makes you rethink your chosen path.
>
> One more thing to think of. If you are using the built in CRUD
> methdology with DataSets, you end up with a translation "layer" for your
> entries to turn them into a List(of T) and back. This is one potential
> source of error. I am not saying avoid this, but ask your motivation
> before you introduce this extra "complexity" into the app.
>
> Peace and Grace,
> Greg
>
> --
> Vote for Miranda's Christmas Story
> http://tinyurl.com/mirandabelieve
>
> Twitter: @gbworld
> Blog: http://gregorybeamer.spaces.live.com
>
> *******************************************
> | Think outside the box! |
> *******************************************