MVVM Light Toolkit Example

In my previous blog, I have showed you some main classes in MVVM Light Tookit. In this blog, I will show a simple MVVM Light Toolkit example. In this example, we will create a sample application for loading and saving the employees details using MVVM Light Toolkit. We will do below tasks one by one: Add a reference of MVVM Light Toolkit into...

Continue Reading

C# Reflection Introduction

Reflection in C# is a big topic in itself. I'll summarize a little list of what you can do with reflection. Get currently executing assembly, load assembly, get assembly from type Get classes declared in assemblies Get methods, properties, fields, events, constructors declared in classes Check access modifiers of classes, properties, fields and me...

Continue Reading

SQL Server Interview Questions Series - Part 2

22. What is SQL Server Trigger? A trigger is a special stored procedure which automatically executes when you execute any insert, update, or delete commands on table or view. 23. Can we execute a Trigger directly? No 24. How many types of Triggers available in SQL Server? There are two types of Triggers: Instead-of Trigger After Trigge...

Continue Reading

SQL Server Interview Questions Series - Part 1

1. What is SQL Temporary Table? A temporary table is a table which developer creates at runtime only for the scope of a query or for the scope of the connection. You can do all CRUD operations on the table. There are two kinds of temporary tables: a. Local temporary table b. Global temporary table Local temporary table: This table is available only ...

Continue Reading

SQL Server Interview Questions Series - Part 3

43. What is the function name for getting the current date in SQL Server? We can use GETDATE() with SELECT statement for getting the current date. SELECT GetDate() 44. Print the name of distinct employee whose date of birth is between 01/01/1950 to 12/31/1970. SELECT DISTINCT Name FROM Employee WHERE DOB BETWEEN '01/01/1950' AND '12/31/1970'...

Continue Reading

.NET Threading Interview Questions Series - Part 1

Q 1.  What is the difference between Process and Thread? A process is started when you start an Application. A process is a collection of resources like virtual address space, code, security contexts etc. A process can start multiple threads. Every process is start with a single thread called primary thread. You can create n number of threads in a process. Threads share...

Continue Reading

.NET Threading Interview Questions Series - Part 2

Q 21. What is the class hierarchy of wait handles? Q 22. What is ManualResetEvent and how it is different between AutoResetEvent? ManualResetEvent is also a synchronization mechanism similar to AutoResetEvent which works on bool variable. If the bool variable is false, it blocks the thread. If true, it unblocks the threads. ManualResetEvent provides the sa...

Continue Reading

WPF Architecture

WPF is a successor of Windows Forms. Earlier Windows Forms uses the Windows Graphics Device Interface (GDI+) for rendering any graphics, and drawing text. WPF is a new framework for developing rich Windows smart client applications that uses the DirectX technology behind the scene. WPF is resolution-independent because WPF uses vector graphics for drawing the controls on the sc...

Continue Reading

WPF BackgroundWorker

To build more responsive WPF UI, we have to use multiple threads that can work in the background and update the UI when the work completed. But background threads can't access the objects created in the STA. Then how can we update the UI when the background threads completed their work?  WPF applications are based on Single Threaded Apartment Model (STA). Ob...

Continue Reading

WPF ComboBox - Tooltip for each item

Many readers ask me a question regarding how we can add a tooltip for each item of ComboBox in WPF. Here I am presenting a very simple solution. In the below example, I am creating a simple combobox. ComboBox DataTemplate defines a ListBoxItem for each item in combobox. ListBoxItem has both Content and Tooltip property.  As we cannot use String.Format in Tooltip bi...

Continue Reading

Join our newsletter and get an occasional email with a technology and DotNetPattern.com news update.