❔ Which ORM? [query sys.objects, ...]
Hey guys
So I already have some decent experience using EF as ORM to create some applications at work.
However... I'm about to start working on 1 of my hobby-projects, and I'd really appreciate some help in deciding which ORM to use.
Some context about the project, which might help in getting good advice:
The project would have its own Database (Master), which would store certain information about another Database (Client) - The question is mainly focused around the Client DB.
Let's also assume I wouldn't want to add any tables/views to the Client DB.
In order to store (useful) information about the Client, I'd like to query its sys.xxx tables
Now the real question... Is there any ORM I could use to query those tables, or should I be looking at writing raw SQL (either using an ORM or not).
Any advice (or feedback on why this is a bad idea?) would be greatly appreciated.
Thanks in advance
Kind regards
Steven
So I already have some decent experience using EF as ORM to create some applications at work.
However... I'm about to start working on 1 of my hobby-projects, and I'd really appreciate some help in deciding which ORM to use.
Some context about the project, which might help in getting good advice:
The project would have its own Database (Master), which would store certain information about another Database (Client) - The question is mainly focused around the Client DB.
Let's also assume I wouldn't want to add any tables/views to the Client DB.
In order to store (useful) information about the Client, I'd like to query its sys.xxx tables
Now the real question... Is there any ORM I could use to query those tables, or should I be looking at writing raw SQL (either using an ORM or not).
Any advice (or feedback on why this is a bad idea?) would be greatly appreciated.
Thanks in advance
Kind regards
Steven
