My works, I'm using NHibernate and Castle ActiveRecord with my Data Model/Repository using MySQL. I don't have to do any kind of hacks to get it working. My primary keys are all Guid type.
I don't know exactly what error you have? The only problem I had when flipping between MSSQL and MySQL is I didn't set "hbm2ddl.keywords" to "none" in the config file. Sorry, I don't remember the error I had with MySQL, I think it was with Guid. What I'm using: ASP.NET 3.5 SP1 MVC 1.0 MySQL 5.0.24a MySQL Connector/Net 6.1.1 NHibernate 2.1.0.GA NHibernate.Linq 1.0.0.GA Castle ActiveRecord 2.0 Sincerely, William Chang http://www.williamchang.org http://www.babybluebox.com On Aug 28, 8:41 am, DannyT <[email protected]> wrote: > I'm having this same issue, just switched from MSSQL to MySQL and struggling > with guid as the identifier field. Did you ever resolve this? > > 2009/6/9 Jorgas <[email protected]> > > > > > > > > > Does anyone have any experience with the above problem? Or isn't > > anyone besides me using MySql? ;) > > > /Jörgen > > > On 7 Juni, 21:54, Jorgas <[email protected]> wrote: > > > Hello! > > > > I have a problem when trying to use Guid:s in NH together with MySql. > > > I use the type System.Guid in my POCO entities and using Fluent > > > NHibernate they get mapped onto VARCHAR(40) types in the database > > > using the MySql Dialect. > > > > I can create new entities, have NH generate the id:s with the > > > generator class Guid (or GuidComb) but when I try to read back > > > entities from the persistent store I get error messages like this: > > > > "Guid should contain 32 digits with 4 dashes". Somehow it seems like > > > if the translation between the database back to a System.Guid doesn't > > > work as intended. Or am I just doing it the wrong way? Should I be > > > using the uuid generator class instead? > > > > Best regards, Jörgen > > --http://danny-t.co.uk --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
