Model View Presenter (MVP) Example - #6 The Repository With ADO.NET
Part 6 of MVP Using WinForms. This video covers creating a repository to be used in a demo application being built to demonstrate an example of Model View Presenter.
Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The overview is in Video #1.
The repository in this video will use SQLite as the database engine. No Object Relational Mapper (ORM) like Entity Framework is being used. The database operations will be performed using only ADO.NET. At some later time in the future a video may be released showing the replacement of the SQLite database using ADO.NET with an SQLite database using Entity Framework or SQL server.
The next video, #7, will present a demonstration of exercising the repository with xUnit for Unit Testing. This is being done because at this stage there is still no user interface with WinForms. We don't have to wait for the GUI to be developed to use the repository. The Unit Testing video will show how the Service Layer is used to access the Repository to get data as well as save and update objects.
Briefly discussed topics in this Video:
1) Setup changes to Visual Studio 2017 for development of the repository
2) Required nuget package
3) New projects added to the Visual Studio solution (Note: All added projects are Class Libraries using .NET Framework, Not .NET Framework Standard)
4) Connection string for SQLite
Follow me on twitter to see what I'm working on and news on upcoming videos. My twitter page is at the below URL:
/ robertgmarquez1
My twitter account is @RobertGMarquez1
Personal website is at:
http://www.robertmarquez.com
Robert Glenn Marquez Samples
Robert G Marquez Samples
Robert Marquez Samples
Author Name Look ups are: Robert G Marquez, Robert G. Marquez, Robert Glenn Marquez, and Robert Marquez.
rgmtechvideos