Message-ID: <20041103192328.96816.qmail@web60708.mail.yahoo.com>
Date: Wed, 3 Nov 2004 16:23:28 -0300 (ART)
From: "Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br>
Subject: Re: Guid and Npgsql C#
To: Aleksandar Dezelin <dezelin32@fastmail.fm>,
	"pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
In-Reply-To: <4188F876.80603@fastmail.fm>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

 --- 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