Working with GUIDs and the HiLo pattern

Whats the deal with the HiLo Table when using GUIDS. I kinda assumed it wouldn't be needed but it complained about invalid object when i added a new object (See dump HiLo) so i ran the script you had there (which to be fair is prolly only going to help for ints) and it now throws an invalid cast (cos it's getting in int from HiLo right!) but I guess i need to tell it not to do that, beyond the class definition

    public class User : Entity<Guid> ....

 Invalid object Exception

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Mindscape.LightSpeed.Identity.KeyTableIdentityGenerator.ReserveIds() in D:\Businesses\Pervasive Group\code\LightSpeed\Trunk\Src\Framework\Identity\KeyTableIdentityGenerator.cs:line 90
   at Mindscape.LightSpeed.Identity.KeyTableIdentityGenerator.get_Next() in D:\Businesses\Pervasive Group\code\LightSpeed\Trunk\Src\Framework\Identity\KeyTableIdentityGenerator.cs:line 65
   at Mindscape.LightSpeed.Mapping.IdentityAssigner.Visit(Entity entity, Set`1 visited) in D:\Businesses\Pervasive Group\code\LightSpeed\Trunk\Src\Framework\Mapping\IdentityAssigner.cs:line 26
   at Mindscape.LightSpeed.Mapping.IdentityAssigner.Assign(Entity entity) in D:\Businesses\Pervasive Group\code\LightSpeed\Trunk\Src\Framework\Mapping\IdentityAssigner.cs:line 12
   at Mindscape.LightSpeed.UnitOfWork.Add(Entity entity) in D:\Businesses\Pervasive Group\code\LightSpeed\Trunk\Src\Framework\UnitOfWork.cs:line 283
   at Mindscape.LightSpeed.Repository.Add(Entity entity) in D:\Businesses\Pervasive Group\code\LightSpeed\Trunk\Src\Framework\Repository.cs:line 281
   at BushidoCode.DynamiteMonkeys.BusinessTest.BizTest.TestUser() in E:\Source\MonkeyAround\BushidoCode.DynamiteMonkey.BusinessTest\TestUser.cs:line 91

O BTW it does seem to leave the database in a rather nasty state around this time i figures its leaving an open transaction.

O BTW BTW it was very easy to get to this point and all your assumptions look sound (in relation to conventions etc) . Looks good gents (although it appears integers for id's may be the way to go) 

Mostly cos i need the friends - it works fine with ints - although it does seem to be holding the database open so i guess there is an 'off' button i couldn't see.

On the plus side it only took a few minutes to change over the primary key and most of that was scripting the database so thats v cool.

 Database is definitely my fault :S

Hey Splinter,

Although it is likely not documented yet, you need to set the IdentityMethod on LightSpeedContext to LightSpeedContext.Guid

Cheers,

Andrew.