search

L00177579 / Studio-Ghiblis-Movie-Maker

0 stars 2 forks source link

Investigate and implement secure CRUD data operations for database #8

Open EoinMorganL00177775 opened 1 year ago

EoinMorganL00177775 commented 1 year ago

The database interaction layer should allow users to securely Create, Read, Update and Delete records dependent on their permission level. Using the most suitable interaction method for the chosen database, these communications need to be implemented and tested.

L00177579 commented 1 year ago

I've not implemented something like this from scratch before so if you find any good documentation or tutorials could you put it in a comment here?

EoinMorganL00177775 commented 1 year ago

@L00177579 I've worked on this in other languages from a pure standpoint where these operations are implemented as custom SQL operations but in C# I have used a framework called EntityFramework that handles the integration layer so you can just treat your db record as an an object and then use an Add(object) function to insert etc. Might be able to use something similar here. Pretty good tutorial on C# & EntityFramework: https://learn.microsoft.com/en-us/visualstudio/data-tools/create-a-simple-data-application-with-wpf-and-entity-framework-6?view=vs-2022

L00177579 commented 1 year ago

Ah so I've used the entity framework. For some reason it skipped my mind. This is what happens if I do things so early in the morning.