Is there a library for converting changes to a C# model to SQL statements?

Question

I'm working on a project for this summer which involves a database of customers. Each customer has fields like FirstName, LastName, CreatedDate, etc. These Customer objects are stored in a SQL DB. I'm building a UI (in Blazor & C#) which exposes the data to users and allows users to edit the data. Upon submission of an edit, a new Customer object is created to store the changes, and is linked to the original (unchanged) object through a special ID field. I would then like to somehow convert the changes made to the model to an 'Update' SQL statement, which will eventually be reviewed, approved and executed on the DB.

I'd like to do this conversion using something more lightweight, like a library. I have done some research and found a few frameworks which may be useful, but I thought that someone in the community may have knowledge of a library which may be implemented more quickly. Thanks for any help y'all can give!

by the way: questions asking for recommendations are explicitely off-topic for stackoverflow. — Franz Gleichmann, Jul 21 '20 at 05:12

Bas · Answer 1 · 2020-07-21T05:14:06.207

3

Have you considered Entity Framework? It's the Microsoft-built library that basically does what you're describing to the letter.

If you are managing schemas, migrations allow you to drive the database schema from code, and reverse engineering allow you to generate code from the database schema.

If you'd like to review generated SQL statements, you can log and review ToTraceString() in your code.

edited Jul 21 '20 at 05:14

answered Jul 21 '20 at 05:01

Bas

26,772
8
53
86

2

@user2864740 But EF can do that too https://stackoverflow.com/questions/14325137/automate-ef-migrations-update-database-script – Martheen Jul 21 '20 at 05:06
@user2864740 it's called "migrations", and it's 50% of why you should even use EF. – Franz Gleichmann Jul 21 '20 at 05:11
OP's question is more about persisting value changes to a database, less about structure changes, though EF is great for that too. – Chris Schaller Jul 21 '20 at 05:27

Is there a library for converting changes to a C# model to SQL statements?

1 Answers1