Postgres Pro
Downloads
Home   >   mailing lists

Thread: Guid and Npgsql C#

Guid and Npgsql C#

From
Aleksandar Dezelin
Date:
Does anybody knows how C# Guids are interpreted in Npgsql assembly?
I want to convert existing C# .NET application which uses MS SQL 2000 
database to Mono and PostgreSQL but I don't know how to deal with all 
Guid fields that it's using. I've found a patch that adds 
uniqueidentifier support to PostgreSQL but I'm not sure how to use it 
from C# and Mono.

Please help.

Thanks in advance,
Aleksandar Dezelin

-- 
Linux is like wigwam - no windows, no gates and apache inside. ...

Re: Guid and Npgsql C#

From
"Francisco Figueiredo Jr."
Date:
 --- Aleksandar Dezelin <dezelin32@fastmail.fm> escreveu: 
> Does anybody knows how C# Guids are interpreted in Npgsql assembly?
> I want to convert existing C# .NET application which uses MS SQL 2000 
> database to Mono and PostgreSQL but I don't know how to deal with all 
> Guid fields that it's using. I've found a patch that adds 
> uniqueidentifier support to PostgreSQL but I'm not sure how to use it 
> from C# and Mono.
> 

Hi Aleksandar.

Unfortunately, Npgsql doesn't support Guid datatypes. You could try using it as
string inside your database and use the NpgsqlDbTypes.Text as the datatype.

Could you provide me a link to this uniqueidentifier patch? I could help you
add this specific type to a custom Npgsql assembly.

Regards,

Francisco Figueiredo Jr.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com