Print Page | Close Window

Using GUIDs

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2422
Printed Date: 07-Jul-2026 at 7:30pm


Topic: Using GUIDs
Posted By: tj62
Subject: Using GUIDs
Date Posted: 06-Jan-2011 at 6:22am
I'm using INformix Dynamic Server 11.5 as database. As the DevForce strongly recommends using GUIDs as primary/foreighn keys I tried to implement that. Unfortunately Informix has no GUID data type. However I found out how I could create a new data type in the database here:
  http://www.ibm.com/developerworks/data/library/techarticle/dm-0401roy/index.html - http://www.ibm.com/developerworks/data/library/techarticle/dm-0401roy/index.html
I did that and it works grate. Even mapping back and forth to/from strings works fine. However when I try to use it with the Entity Framework I get this messages:
 
"The data type 'guid' is not supported; the column 'id_gud' in table 'testDB.informix.guid_test_table' was excluded."
 
Pretty sad! Has anyone any experience with this using other database engines than SQL Server?
Maybe the only alternative is using serials (autincrements).
 


Replies:
Posted By: sbelini
Date Posted: 13-Jan-2011 at 11:09am

Hi tj62,

I'm trying to reproduce your environment so I can better investigate the issue, but I'm coming accross some issues.
 
What data provider are you using? I could find OpenLink .NET Data Provider and IBM Data Server .NET Provider, but both support .NET3.5 and VS2008 only.
Please let me know how you set your environment with DevForce2010 and VS2010.
 
sbelini.

Posted By: tj62
Date Posted: 14-Jan-2011 at 1:23am
Yea that was a good question. There only exist an open beta for .NET 4.0. We have been using it problem free for many months now. You can download it at:
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=345634&tstart=0 - http://www.ibm.com/developerworks/forums/thread.jspa?threadID=345634&tstart=0
or direct link:
https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swerpdb2-datadv10-3 - https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swerpdb2-datadv10-3
but you need a login to download that you can easily create.
 
For us the installation instruction from IBM was rather little help, we created our own, and I attach it here:
http://www.ideablade.com/forum/uploads/508/Guide_for_installing_IBM_DB_for_VS2010.zip - uploads/508/Guide_for_installing_IBM_DB_for_VS2010.zip
 
If yo have any problems, installing, let me know.

Finaly I realy appreciate your support.
 
Regards
  TJ

Posted By: sbelini
Date Posted: 20-Mar-2011 at 10:08pm
Hi TJ,
It looks like there's no way to use Informix Guids with DevForce/EntityFramework... At least for now.
The IBM Data Provider is still a Beta, so let's hope they implement this feature in the near future.
Silvio.


Print Page | Close Window