S
S Chapman
Is there any tool that generates Typed DataTables rather than Typed
Datasets? The trouble we are having is we have quite a few tables in
our database and a single table can be a part of more than one dataset.
If we use the XSD.Exe, the datatable definitions are repeated in every
dataset they appear in; causing our data definition layer to bloat.
Let us say there is a database table called Account which appears in
two dataset definitions - AccountData and TransactionData, XSD.Exe
creates two copies of Account datatable. This is very bad design as the
same underlying table is represented as different .net types.
We have looked at CodeSmith but it does not seem to provide any
out-of-the-box templates for what we are looking. We could write our
own templates but we are trying to avoid it to see if there is a better
way of coping with the problem.
Thanks.
Datasets? The trouble we are having is we have quite a few tables in
our database and a single table can be a part of more than one dataset.
If we use the XSD.Exe, the datatable definitions are repeated in every
dataset they appear in; causing our data definition layer to bloat.
Let us say there is a database table called Account which appears in
two dataset definitions - AccountData and TransactionData, XSD.Exe
creates two copies of Account datatable. This is very bad design as the
same underlying table is represented as different .net types.
We have looked at CodeSmith but it does not seem to provide any
out-of-the-box templates for what we are looking. We could write our
own templates but we are trying to avoid it to see if there is a better
way of coping with the problem.
Thanks.