DNN MVC Module with Sql Hierarchy Id

Question

Quick question here. Has anyone used the sql hierarchy id type in their dnn mvc module with peta poco? Do you need to write a custom query to cast the data type? Do you need to add sql server types to the project?

Thanks!

Answer 1

Out of the box, PetaPoco doesn't support this type. However, PetaPoco does support some flexible mapping points.

Off the top of my head, you can declare your own mapping type. See Interface & Docs & Registration

Another method is to hook the type mapping using the fluent configuration method. See example & Docs