Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select from one strongly typed dataset to another
Message
From
08/07/2011 03:23:21
 
 
To
07/07/2011 14:09:31
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
C# 3.0
Miscellaneous
Thread ID:
01517609
Message ID:
01517664
Views:
23
>>>Then why use two different strongly-typed datasets in the first place ?
>
>Ah.. you ask those probing questions, Viv.
>The source tables here are VFP. They are reference tables that aren't updated by this app, and have record counts less than 1K.
>
>
>The nature of this app is such that as many as 10 queries of those tables might be required by a transaction before the final result for that transaction can be determined.
>
>In order to avoid going back to the VFP sources repeatedly, I load one dataset with them when the app loads and plan to query from that DS to another while executing the transaction at hand.
>My assumption is that a query against a low record count DT will be a lot faster than a round trip to a VFP table.
>I can get them into a datarow OK but I'd like to use intellisense here because a lot of fields are used in the calculations, so I conjured up the second instance of the dataset as a solution.
>
>There are not two .xsd's - just two instances of the same .xsd.

Ah, OK. I thought you meant that you had two different classes (Strongly typed DS) defined which both happened to have the same structure. Makes sense now (assuming you are not worried about currency issues with the VFP backend)

Bonnie's suggestion looks good but I haven't touched a dataset in months - all EF now :=}
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform