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