UdtTypeName property must be set for UDT parameters.

Guys, any idea what this exception means and how to fix the problem?

TIA:

Test method DAL.Test.DAL.TestInsertAgentLocation threw exception: 
System.ArgumentException: UdtTypeName property must be set for UDT parameters.
at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters)
at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, ref _SqlRPC rpc)
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 ..
.ƒ()
at Mindscape.LightSpeed.Profiling.Interceptor.ExecuteCommand(Func`1 baseExecutor, IUnitOfWork unitOfWork, IDbCommand command)
at ..ƒ(IUnitOfWork , IDbCommand , Func`1 )
at ..ƒ(IUnitOfWork , IDbCommand )
at ..ƒ(Entity ,  )
at ..ƒ(Entity , ICollection`1 )
at ..ƒ(Entity , List`1 )
at ..ƒ(UnitOfWorkBase , IEnumerable`1 , IEnumerable`1 )
at Mindscape.LightSpeed.UnitOfWork.SaveChanges(Boolean reset)
at Mindscape.LightSpeed.UnitOfWorkBase.SaveChanges()
at LbsServices.DataAccessLayer.Entities.AgentLocationRepository.Create(String name, AgentLocationDTO newEntityDTO) in AgentLocationRepository.cs: line 158
at DAL.Test.DAL.TestInsertAgentLocation

It looks like your entity has a field which is of a custom type, and SQL Server thinks that type is a SQL Server 2008 UDT, but we don't and therefore aren't passing the necessary hint into SQL Server.

One way this could happen is if you are using the SqlServer2005 provider along with SQL Server 2008 types such as SqlGeography. To use SqlGeography etc., you must specify the SqlServer2008 provider in your LightSpeedContext. (In the designer, the 2005 provider works with both versions, but the runtime does make the distinction.)

If that's not it, could you post the definition of the entity type you are inserting? (Just the fields will do, we don't need to see all the wrapper properties.) Thanks!

Thanks Ivan, that was it.

I was programmtically creating the LightSpeedContext without setting the DataProvider explicitly to SqlServer2008. I think it defaults to SqlServer2005 and since my table has SqlGeography, it threw the exception. That was good postulation.