search

PowerShellOrg / tug

Open-source, cross-platform Pull/Reporting Server for DSC
Other
162 stars 27 forks source link

EF Core Bundle Support #69

Open kamranayub opened 7 years ago

kamranayub commented 7 years ago

Thread for discussion regarding supporting an EF Core store provider for better reporting/storage.

Selfishly, I'm only looking to support MS SQL but EF Core is nice in that it's supposed to be agnostic (or at least, support being agnostic). Perhaps defining what the interface should look like is a good place to start, as well as the "schema" that the ESENT database uses currently in vanilla pull server (which can be viewed using ESE Database Viewer.

Table schemas (mdb file)

image

image

image

ebekker commented 7 years ago

Thanks for kicking off this discussion and providing a starting point for the schema. Can you clarify, is your screenshot showing what the schema of the current ESENT database includes, or is that just a sample you're put together? Because all 3 entities have the same structure in your example.

kamranayub commented 7 years ago

It's supposed to be the MDB file (since I'm not using ESENT), but you're right--looks like a bug with the program, it's showing the exact same fields in each table 👎 I can try again, that's weird.

ebekker commented 7 years ago

I've started a collaborative workspace on this wiki page that we can use to hash out some ideas. I've started with your schema above. We can use this ticket to "discuss" ideas and capture design in the wiki.