![Robert G Marquez](/img/default-banner.jpg)
- 18
- 334 375
Robert G Marquez
United States
Registrace 2. 09. 2012
Use Azure Data Studio to Load Wide World Importers Database File To SQL Server 2019
Import the free database Wide World Importers from a .bak file into SQL Server 2019. Azure Data Studio is the tool used in this video to load the database.
========================================================================
The free database is in a GitHub repository
Database Name: Wide World Importers
The URL is:
github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
========================================================================
File Name: WideWorldImporters-Full.bak
Additional information regarding the free databases for SQL Server
docs.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16
=========================================================================
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:
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
========================================================================
The free database is in a GitHub repository
Database Name: Wide World Importers
The URL is:
github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
========================================================================
File Name: WideWorldImporters-Full.bak
Additional information regarding the free databases for SQL Server
docs.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16
=========================================================================
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:
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
zhlédnutí: 790
Video
Sample Motion Graphics - Affect Systems
zhlédnutí 253Před 4 lety
Sample motion graphics video I created with Cinema 4D and Sony Vegas of a fictional business named Affect Systems. 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: www.robertmarquez.com Robert Glenn Marquez Samples Robert G Marquez Samples R...
Model View Presenter (MVP) Example - #10 Views and Presenters
zhlédnutí 8KPřed 6 lety
Video #10 Part 3 of Model View Presenter (MVP) covering Views and Presenters. Visual Studio 2017 development of the Views and Presenters using C# for a demo application. WinForms is being used for the graphical user interface. It will take several videos to cover this topic. Note that although WinForms is being used for the user interface, the other parts making up the engine such as service la...
Model View Presenter (MVP) Example - #9 Views and Presenters
zhlédnutí 8KPřed 6 lety
Video #9 Part 2 of Model View Presenter (MVP) covering Views and Presenters. Visual Studio 2017 development of the Views and Presenters using C# for a demo application begins with this video. WinForms is being used for the graphical user interface. It will take several videos to cover this topic. Note that although WinForms is being used for the user interface, the other parts making up the eng...
Model View Presenter (MVP) Example - #8 Views and Presenters
zhlédnutí 6KPřed 6 lety
Video #8 Part 1 of Model View Presenter (MVP) covering Views and Presenters. This video begins the discussion on the Views and Presenters part of MVP. Videos before this one covered areas of MVP prior to development of the user interface part. Note the overview video is in Video #1. Briefly discussed topics in this Video: - Demonstration of the Model View Presenter demo application - High level...
Model View Presenter (MVP) Example - #7 Repository Unit Testing With xUnit.NET
zhlédnutí 4,1KPřed 6 lety
Part 7 of MVP Using WinForms. This video shows how the repository is used by the services layer. This will be done by using the xUnit unit testing facilities to act as an interface to tell the service layer to perform repository actions. 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. Briefly discussed topi...
Model View Presenter (MVP) Example - #6 The Repository With ADO.NET
zhlédnutí 9KPřed 6 lety
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 Mapp...
Model View Presenter (MVP) Example - #5 Unit Test Setup With xUnit.net
zhlédnutí 9KPřed 6 lety
Part 5 of MVP Using WinForms. This video covers setting up a Unit Test project using xUnit.Net in Visual Studio to test the Services Layer. 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. If you are not interested in unit testing an application then you should skip this video and move onto video #6. Video #...
Model View Presenter (MVP) Example - #4 Creating A Service Layer
zhlédnutí 15KPřed 6 lety
Part 4 of MVP Using WinForms. This video covers creating a services layer for use by the Presenter. The Presenter will use services in the Service Layer to carry out tasks such as send and receive model data from the repository. The Service Layer will also transform model data when needed for data being sent to the Presenter for use by the View. Note that video #8 is where coverage of the Prese...
Model View Presenter (MVP) Example - #3 Creating Models With Data Annotation Validations
zhlédnutí 13KPřed 6 lety
Part 3 of MVP Using WinForms. It covers model creation. 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. Briefly discussed topics in this Video: 1) Using Visual Studio 2017 to create a new solution 2) Create a Class Library project with .NET Framework support to be used as the Domain Layer 3) Creation of fol...
Model View Presenter (MVP) Example - #1 Overview
zhlédnutí 51KPřed 6 lety
This is part 1 of Model View Presenter (MVP) Using WinForms. The focus in this video is to provide an overview of how MVP was implemented in a WinForms application. Videos demonstrating how Visual Studio 2017 was used with C# and WinForms begin with video #3. Note that video #8 is where coverage of the Presenters and Views begin if that is what you are looking for. The coverage of Model View Pr...
Model View Presenter (MVP) Example - #2 SQLite Setup
zhlédnutí 11KPřed 6 lety
This is part 2 of MVP Using WinForms. It covers setting up SQLite for the Model View Presenter WinForms demo application. The use of Visual Studio 2017 will begin with video #3 which starts with model creation. 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. Briefly discussed topics in this Video: Using DB ...
Tutorial - Create A Matrix Report With SSRS and Visual Studio
zhlédnutí 2,1KPřed 8 lety
This tutorial demonstrates how to use the SSRS template for Visual Studio 2013 to create a matrix report. I created this video to demonstrate my knowledge of SSRS as well as my ability to use the following tools to create videos: - TechSmith Camtasia - Sony Vegas Studio 13 - Cinema 4D (Intro and ending) - Adobe Photoshop - Mixcraft Pro Studio 7 (music) Personal website is at: www.robertmarquez....
Tutorial - VMWare Workstation 8 Tips and Tricks
zhlédnutí 2,8KPřed 8 lety
Tutorial demonstrating several features of VMWare Workstation 8 such as the following: - Accessing files on your PC from a virtual desktop session - Suspending and restoring a session - Recording a virtual machine with the movie recorder - Access files outside of the virtual machine Personal website is at: www.robertmarquez.com Robert Glenn Marquez Samples Robert G Marquez Samples Robert Marque...
IIS 8.5 Tutorial #1 - Adding an additional website on Windows Server 2012 R2
zhlédnutí 10KPřed 8 lety
Tutorial showing how to add an additional web site on Windows Server 2012. Topic demonstrated are as follows: - How to create a virtual IP address for a web site on an intranet - IIS Manager 8.5 to create a site - DNS Manager to assign a friendly name to a site instead of an IP Address - Simple testing of a sample .NET WCF web service - Simple testing of a standard ASP.NET page - Simple testing...
Sequence Diagram #1 Using Enterprise Architect 12 Tutorial
zhlédnutí 77KPřed 8 lety
Sequence Diagram #1 Using Enterprise Architect 12 Tutorial
Activity Diagram Using Enterprise Architect 12 Tutorial
zhlédnutí 45KPřed 8 lety
Activity Diagram Using Enterprise Architect 12 Tutorial
Use Case Diagram Using Enterprise Architect 12 Tutorial
zhlédnutí 60KPřed 8 lety
Use Case Diagram Using Enterprise Architect 12 Tutorial
Hey there, God bless your efforts. I a a newbie sql learner with a simple enquiry. Where can i find a table with its properties that i have already created in sql managment studio? Thanks for taking care of this.
Nice and very useful explanation.Thanks ..!!!
Very nice and concrete explanation of MVP
Thank you for great videos Robert. I have been trying learn how to use the MVP pattern in my projects but haven't been able to find many articles on how everything interacts with each other specifically. From other guides on how the View and Presenter interact with each other I had always pictured it as something like view holding reference to Presenter and when user clicks button, button click event is raised in the view and calls method through the presenter reference. I never thought about the presenter subscribing to the event in the view so that the presenter can handle how it reacts to the event directly, instead of the view telling the presenter which methods to run when the event is raised.
Thank you! helpful for me
Thank You!
I have also found this tutorial on MVP: code.tutsplus.com/courses/windows-app-from-scratch
Thank you! Very useful video!!!
Please make another enterprise tutorial. Ur vids really help me, thankyouu ❤❤❤
thank u alot ver informative
best tutorial ever thanks man
thankyou for the tutorial
Thank you Robert G Marquez. A lot of information here. i could able to learn not only EA Sequence diagram also some more UML elements and detailed Sequence diagram. Now I will apply these in my applications. Eagerly looking for some more videos regarding UML in your playlist.
Well done! Thank you for the concise explanation.
Thanks a lot. Great video series and very well explained. I'm trying download the source code to explore but the available link on www.robertmarquez.com/Videos/MVP is dead. Could you please restore the link? Again, thanks.
Thanks! Data annotation part [ 7:22] is really interesting. www.completecsharptutorial.com/asp-net-mvc5/data-annotation-validation-with-example-in-asp-net-mvc.php 👈 This is the link reference as a quick access.
Thanks sir
Thank you so much for your detailed explanation dear friend! It was a pleasure to watch your video
can you please add sample code in details
Hello Mohsin. View the details description for video #10. You will find the download link there which provides the project for this video series which includes sample code for this video, #3.
The source code up to video number 10 is now available at the following location: www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip I won't have much time to work on this series for awhile
thx bro you really help my life
Very practical.
Well explained.
Thank you for this really helpful solution! Could you please give me a link where to download the demo's project code.
www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip
Waiting for next video... Thanks in advance.
The tutorial was fine, but where do I get another view or more examples of how to do this kind of diagrams, more examples with UML. Thanks a lot.
Hello Luis. The only videos I have using EA are already on CZcams. I created those videos a few years ago to serve as a reference point for me to go back and re familiarize myself on how to use the tool later in the future. There are many videos like it on CZcams as well as several on the EA website. Just type the following search phrase on google: enterprise architect uml tutorial I probably would do more videos if I were to upgrade to version 14 but I am still using version 12 as it still meets all my current needs so I don't think I'll be purchasing an upgrade soon. If you send me a note identifying the kind of system you are trying to represent in a UML diagram I can give it consideration so if I do create another one it can hopefully come close to providing answers to the things you are looking for. For example, indicate if you are trying to create a sequence diagram for a web application processing a sales order or a desktop app performing typical client server CRUD operations etc. If you do this then it will give me an idea if I can create a video that is helpful but keep in mind there is no promise to create anything here.
I am following you and working on a project, waiting for next video...
Thanks much. Nicely explained. Could you please share this demo Project Code link!
I will try to make the Visual Studio project and code available this weekend.
The source code up to video number 10 is now available at the following location: www.robertmarquez.com/downloads/MVPDemo20180805(WithSqlLightDB).zip I won't have much time to work on this series for a while
Yes, there will be a video number 11 for this series but due to other activities I am busy with I don't see it being released until probably September this year. I might release other videos this month on other topics I have a more immediate need for but it's too soon to know.
Thanks a lot. Great video series and very well explained. I'm trying download the source code to explore but the available link is dead. Could you please restore the link? Again, thanks.
Awesome Tutorial explained very well!
Again - Thank you!
Thanks a lot for these videos. Really helpful. Waiting for next videos... Awesome.....
Thank you so much!
Next video! Cool! Thanks a lot.
Thank you!
Really helpful, thank you!
Thank you, Robert.
Thank you for your videos Robert. They are very helpful.
Hi Robert. Any update on the presenter and view? Thank you.
Great videos. Question: First time I see service class implementing IRepository. Can you point to an article about this design pattern? In most cases I use it under IService interface.
Hello Pawel. While the service layer does have some method names that match those of the repository, it does not carry out the actual implementation. If you watch video #7, you will see how the Service Class is used to achieve data access operations by calling Repository methods and not by actually performing any database operations. . The actual implementation is in the Repository Class itself which you will see when you watch video #6. The reason this demo application service class is matching repository names only is so the Presenter part of the application goes through the Service class. I don't want the Presenter to communicate with the Repository. The Presenter will have to go through the Service class. This is a personal choice. Others may wish to talk to the Repository directly from the Presenter class. I went through the Service class to minimize code in the Presenter class. In some cases, a request for data from the Repository will require the return information to be transformed into something different like a DTO. I want all data transformations to take place in the Service Class as well rather than the Presenter. I want the Presenter to act as much as possible like a coordinator or foreman. I want the Presenter to focus on directing the work that needs to be done by other objects who have been identified as the labor workers of those tasks. Even so, the Presenter will still have a good amount of code in it to get things done. You can see an published example of a service class communicating with a repository in a book titled: Professional Enterprise .NET Chapter 3 look at the ReturnOrderService class. Keep in mind the video series I am putting together is using a small demonstration application. If it were a larger application requiring a wide variety to data access requests then the limited methods names I am using in the service layer (getall, getbyid, etc.) would not be enough. I would need to use other names in the service such as GetHighestRankDeptInNorthTerritory. So for now it looks like the Service Class is the Repository at a quick glance but it is not. The names it has for now are pass through names to the repository and will definitely not match as more customized data access needs arise.
Thank you
Thank you Robert. I hope part 6 will be uploaded soon.
Video #5 should be ready by Friday, May 16 or sooner this week. It will cover the setup of a unit test project with a product called xUnit to test the service layer. A unit test setup will allow confirming various added C# modules actually work without having to build a GUI or console app to test invoke the modules. Coverage of the repository most likely will not be in Video #5 as I am trying to keep each video less than 15 or 20 minutes, it is too soon to know at this point. It may be possible Video #6 could also be released by this Friday as well. The repository will most likely be in Video #6.
I want the next parts 😀 please
Thanks Robert. When will you upload the other parts (Repository, Presentation and View)?
I was just googling this :D Thanks!
Thank you for this video. No one ever explains setting up the IP address and the forward looking zone. That key bit of information is what I needed to resolve the issue I was having. Thanks again
Awesome Tutorial
Robert Marquez: 1 Your's is one of the rare correctly developed UseCase Diagram. 2: You have rightly identified the software developer to be the user of UseCase Diagram and related documentation. 3: You associated only one Actor correctly with each UseCase, though other Actors have to act on the Actor has done. Many people wrongly associate other Actors with the same UseCase. 4: Your UseCase Names are expressive. Glad to find first error-free UseCase Diagram. I am surprised there are no comments so far. Other erroneous and misleading videos are highly appreciated by many learners. I hope more learners will watch and appreciate your video. I want to know, does the Enterprise Architect alert you if the user makes any mistakes?
Thank you very much sir. You've really helped me understand it