New Posts New Posts RSS Feed: Using GUIDs
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Using GUIDs
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
tj62 View Drop Down
Groupie
Groupie
Avatar

Joined: 21-May-2009
Location: Iceland
Posts: 81 		Post Options Post Options   Quote tj62 Quote  Post ReplyReply Direct Link To This Post Topic: Using GUIDs
    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:
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).
 
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 735 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
tj62 View Drop Down
Groupie
Groupie
Avatar

Joined: 21-May-2009
Location: Iceland
Posts: 81 		Post Options Post Options   Quote tj62 Quote  Post ReplyReply Direct Link To This Post 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:
or direct link:
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:
 
If yo have any problems, installing, let me know.

Finaly I realy appreciate your support.
 
Regards
  TJ
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 735 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down