Okay then, I have been enjoying myself today writing X# code and getting the more interesting parts of my 'Stock' app to work in real time.
After advancing my code quite a bit, I have done some live screen tests while making a video clip of what I have input from the mouse and keyboard, and what happens to my data under the control of EF6.
Its not been too often that we all could share a video of a SQL data base being created and populated in real time, with lots of Order data. I also demonstrate in real time the new Delete/Remove screen that allows me to remove Entities. This means that the referential integrity is completely taken care of by the EF6 system - its like magic !!!
Fist I will attach a video clip of me successively removing customer entities, where EF6 also removes the Orders and OrderLine entities relating to each customer. Eventually all 5000 plus Orders and many more order lines are removed from the backend data source, without the need for lots of my code. Oh! this is ADO.NET on steroids, and some!
Lets start with the removal process :-
Now that we have destroyed most of the data, (only a few products and suppliers remain), let us run a second and shorter video click which shows the re-creation of the SQL database, and its seeding with suitable and random data. Check this out :-
The reason we need to re-start the applet is because there is an open link of some sort from the Delete/Removal code which stops the DB from being deleted and re-made. This link is closed in time - BUT - we can't wait while the video camera clicks and whirrs away.
Remember, all the work for this has been done on the .NET side of the code design and creation - no SQL table work in Management Studio, nothing but the good old X# syntax we all like, and the .NET framework and Roslyn compiler support - GREAT !
Must shoot, wife has returned from a full day out at meetings - that's how I got so much work done.