C# Inheritance
Basic Inheritance public class Animal{ public void Greet() { Console.WriteLine("Hello, I'm some sort of animal!"); }} public class Dog : Animal{ } Animal animal = new Animal(); animal.Greet(); Dog dog = new Dog(); dog.Greet();
Author
Access Modifiers and Access Levels
The following access modifiers are available: C# Modifier Definition public The type or member can be accessed by any other code in the same assembly or another assembly that references it. private The type or member can only be accessed by code in the same class. protected The type or member can only be accessed... » read more
Windows Presentation Foundation (WPF)
Windows Presentation Foundation (WPF) is a graphical subsystem by Microsoft for rendering user interfaces in Windows-based applications. WPF, previously known as “Avalon”, was initially released as part of .NET Framework 3.0 in 2006. WPF uses DirectX and attempts to provide a consistent programming model for building applications. It separates the user interface from business logic, and resembles similar XML-oriented object models, such as those implemented... » read more
Model–View–ViewModel (MVVM)
View Model – Data View – XAML, bind to data-model Model – Business Logic MVVM facilitates a separation of development of the graphical user interface from development of the business logic or back-end logic (the data model) The Model View ViewModel (MVVM) is an architectural pattern used in software engineering that originated from Microsoft which is specialized in the Presentation... » read more
Domain Driven Design
Domain-driven design (DDD) is an approach to software development for complex needs by connecting the implementation to an evolving model. The premise of domain-driven design is the following: placing the project’s primary focus on the core domain and domain logic; basing complex designs on a model of the domain; initiating a creative collaboration between technical and domain experts to iteratively refine a conceptual... » read more
SQL Server Utility Explorer
Utility Explorer works inside of Management Studio, so it uses the same familiar interface that you already know. In Management Studio, to switch to the Utility Explorer, go up to the View menu, and then click on Utility Explorer. Using the SQL Server Utility application, they can gather information about the status, health and performance... » read more
SQL Server Activity Monitor
The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes. Right Click Server -> Activity Monitor The Activity Monitor is split up into a couple of different panes. Overview Processes Resource Waits data file input output Recent expensive queries Active expensive queries
Database Waits and Deadlocks
Waits Waits occur when system resources are busy processing other tasks, and new tasks are placed into a holding queue until resources free up. Locks on data are the only reason a task will encounter a wait. Bottlenecks and hardware resources are also common contributors to a task having to wait before proceeding. A dynamic... » read more
Transaction Isolation Types
As we know that, in order to maintain consistency in a database, it follows ACID properties. Among these four properties (Atomicity, Consistency, Isolation and Durability) Isolation determines how transaction integrity is visible to other users and systems. It means that a transaction should take place in a system in such a way that it is... » read more
Implicit vs Explicit Transactions
SQL Server supports both implicit and explicit transactions. Implicit transactions are initiated when the system’s session option “Implicit Transactions” is set to ON. In this state, any of a number of commands, including Create, Insert, Update, Delete, Drop, and Select will automatically begin a new transaction. To finalize the transaction, the user must specifically issue... » read more