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 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 Interview Questions for Beginners & Advanced - Part 1

1. What is WPF? Windows Presentation Foundation (WPF) is a successor of Windows Forms. WPF is a UI presentation framework for developing Windows based applications. It uses the DirectX technology for rendering their controls on the screen. 2. What are the features of WPF? WPF main features are: WPF is resolution-independent. It uses the hardware accel...

Continue Reading

WPF Interview Questions for Beginners & Advanced - Part 2

21. How can we find resources from ResourceDictionary and apply on controls? ResourceDictionary stored resources as key value pairs and you have a method called FindResource in every control to find the resource from the ResourceDictionary. Every resource is stored as reference type so you have to cast the object to the original type. btn1.Background = (Brush)btn1.Fi...

Continue Reading

WPF Interview Questions for Beginners & Advanced - Part 3

41. What is Markup Extension in WPF? Markup Extension decides at runtime how to set a property value. StaticResource, DynamicResource are examples of Markup Extension. Markup Extension are always comes in curly braces { }. The first word inside the curly braces is class name of Markup Extension. 42. How many types of Markup Extension exists in WPF? There are tot...

Continue Reading

WPF Interview Questions for Beginners & Advanced - Part 4

61. How can you obtain the SynchronizationContext class? You can use the static property SynchronizationContext.Current property from the UI thread. 62. How many methods are available in SynchronizationContext class? There are two methods: Post Send 63. What is the difference between Send and Post methods in SynchronizationContext class? Post method...

Continue Reading

WPF Interview Questions for Beginners & Advanced - Part 5

81. What is Property-based Animation in WPF? WPF introduces a property-based animation techniques to make animations in WPF easy. It simply modify the value of control property over an interval of time and the target property must be a dependency property. 82. How many types of Animation support by WPF? There are baiscally three types of Animation classes. ...

Continue Reading

C# Convert string to int

In C#, there are there ways for converting string to int. Each way has its own advantages and disadvantages. These ways are: int.Parse method int.TryParse method (Best way) Convert.ToInt32() method int.Parse method int.Parse method converts string input into integer. It takes the string input and returns int as output. static void Main(...

Continue Reading

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