Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting SQL Server uniqueidentifier to .NET Guid type
Message
From
31/03/2009 00:09:28
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 3.0
Database:
MS SQL Server
Miscellaneous
Thread ID:
01391015
Message ID:
01392279
Views:
54
>That is what we were told by more than one "consultant" when we started planning our VFP port to Sql Server 2005.

Have you tried it? Just curious ...

~~Bonnie





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 ).
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform