StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1059444
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-06-29T17:20:53.937
FavoriteCount
0
LastActivityDate
2009-06-29T17:26:28.860
LastEditDate
2009-06-29T17:26:28.860
LastEditorUserId
44894
OwnerUserId
44894
ParentId
1057824
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
<ol> <li>The typed dataset/table is database independent. (however, if you add adapters in the designer they get DB-specific.. Don't use adapters from the designer </li> <li>The adapters ARE NOT database independent. </li> <li>Databinding is database independent. But beware of drag-drop databinding automatically adding an adapter </li> </ol> My advice: <ul> <li>Remove the adpaters from the dataset designer</li> <li>Rewrite your own repositories/adapters using a simple class with methods that get/fill tables. So you use them instead of the generated adapters. These classes can be DB-specific. So for instance a PersonRepositorySqlServer,PersonRepositoryMySql. Or perhaps you give the db-type with the constructor to reuse the SQL as much as possible.. </li> <li>If you used adapter on your forms, remove them to. Hand-code the filling of the dataset</li> </ul> What I always do to answer the rest of the questions <ul> <li>I use typed datasets but I just make the tables and not the adapters</li> <li>I Usualy code the databindings since sometimes the designer messes up but this is not necessary to be db independent</li> <li>I write my own repositories that use adapters to fill/get/update the datatables. However I code them by hand. Given a typed datatable it's rather easy to auomatically generate update/insert/delete/fill statements by the way..</li> </ul> Rewriting the adapters looks hard but is actually pretty doable. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PO.Net: how to create vendor independent Dataset, Tableadapters, bindings (DB decided at runtime)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJulian de Wit
UserOwnerUserId
1. USJulian de Wit
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PO.Net: how to create vendor independent Dataset, Tableadapters, bindings (DB decided at runtime)
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COdo you have some working example about this?
 singulars
 PostPostId
 PO
 UserUserId
 USauraham

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.