Hi,

I am using Guid for the ID type, and when I invoke the object Load(Type theType, object id)method, it throws the exception: System.Data.SqlClient.SqlException: Incorrect syntax near '-'.

The id tag defined in the hbm file is like this:

<id name="ID" column="ContactProfileID" type="Guid">
<generator class="assigned"/>
</id>

did anyone meet the issue before?

Please read the guidelines on how to do a proper request for help. Your post is incomplete so its practically impossible to understand what is going on. So don't expect too many replies!

As a wild guess I think the datatype you use to pass the guid is not appropriate and the generated SQL doesn't enclose the guid in quotes. But there are many things involved: the mappings, the code, the dialect etc.

cheers,
Radu