ORMLite to access SQL SERVER DMV Tables

ServiceStack.OrmLite SQL Server
1

Did anybody tried to build a small UI to extract info. From the DMV Tables. I would like to keep the last query executed during x days.

Is it possible to create a datamodel and use OrmLite to read those DMV tables ?

Does the Alias attribute will be enought to map the DMV tables ?

Thanks,
André

2

I’ve never done it before but i can’t see why you can’t create access it like any other resultset and create a custom Type that matches the results schema or access it via dynamic resultset APIs.

1 Like