Suppose you have implemented a multi tiered application. On the data tier (which is physically on a different machine than the application tier) we have MS SQL. Now SQL stores its dates internally however it sees fit.
From the application tier, we run different queries against the data tier. Say we run a sql query to get a specific date. Even if we used Typed Data Sets, how is the .net runtime able to determine the schema of the field within the dataset (ie. if we have different regional settings on each of the Tiers: dd/mm/yyyy vs mm/dd/yyyy).
Is there some sort of metadata in the serialized dataset that describes the schema to prevent data integrity problems?