DevForce Community Forum : Using GUIDs

DevForce Community Forum : Using GUIDs http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Using GUIDs Wed, 22 May 2013 19:10:54 -700 Sun, 20 Mar 2011 22:08:16 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2422 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Using GUIDs : Hi TJ, It looks like there's... http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=10221#10221 Author: sbelini
Subject: 2422
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.

]]> Sun, 20 Mar 2011 22:08:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=10221#10221 Using GUIDs : Yea that was a good question.... http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=9649#9649 Author: tj62
Subject: 2422
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

or direct link:

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:

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

]]> Fri, 14 Jan 2011 01:23:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=9649#9649 Using GUIDs : Hi tj62, I'm trying to reproduce... http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=9644#9644 Author: sbelini
Subject: 2422
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.

]]> Thu, 13 Jan 2011 11:09:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=9644#9644 Using GUIDs : I'm using INformix Dynamic... http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=9572#9572 Author: tj62
Subject: 2422
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

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

]]> Thu, 06 Jan 2011 06:22:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2422&PID=9572#9572