Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting SQL Server uniqueidentifier to .NET Guid type
Message
 
To
30/03/2009 16:01:31
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 3.0
Database:
MS SQL Server
Miscellaneous
Thread ID:
01391015
Message ID:
01392210
Views:
54
That is what we were told by more than one "consultant" when we started planning our VFP port to Sql Server 2005. They said since we have a method of providing unique integer keys then continue to use those and let Sql handle the GUID's if it needs them. Once you start setting up your publisher and subscriber it adds one GUID column to each table in the replication schema for GUID's. If you drop replication is supposedly drops the GUID columns too ( can't say I've seen that though ).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform