Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Guids
Message
From
19/06/2008 19:13:57
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
Re: Guids
Environment versions
Environment:
C# 3.0
OS:
Vista
Database:
MS SQL Server
Miscellaneous
Thread ID:
01325529
Message ID:
01325594
Views:
19
I sorta meant that as a test. I don't know how many records you are working with but some testing would find the answer to how they need to be changed in order to fit into SQL. I have just done a ToUpper() and they went right in, but it would depend on the format you have. For instance do they look like this:
{1C285071-CB16-496a-B800-C9C1FC4DAA3C}

I find it very interesting about the 4 in the 15th position Charles mentioned. I had never heard of that and don't know what that means, but I see it holds true.
Tim

>
>So you are saying execute a ToUpper() on each guid type column in every row before I call the Bulk Copy? I guess that means leave the fox table type as C(36) and not a varbinary.
>
>That could be really slow depending on the number of guid columns times the number of rows in each data table. I was hoping more to know which data type I can leave the fox tables guid columns in and have it move from fox to C# dataset to Sql table without any major hoops. I guess there is none.
Timothy Bryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform