C# Basics OOPS Angular JS Learn Javascript Framework Learn Design Pattern LINQ and EF Interview Question VSTS Testing Learn .Net 60 days C# Threading Q&A Videos Understanding Software Architecture Function Points UML MVP Learn MVC 5 ASP.NET Q&A Generics/.NET collections Q & A .Net Fundamentals C# Threading Q & A HTML 5 and CSS 3 SQL Server Q&A ADO.Net Q&A Interview Q&A WCF Q&A Tips and Tricks .NET Projects Understanding OOPS SDLC Function Point Enterprise Application Blocks LINQ Q&A Knockout Q&A Localization/Globalization
  1. What is Globalization and Localization? - Part 1
  2. How can we set explicit culture? - Part 2
  3. What is the difference between Culture and UI Culture? - Part 3
  4. How to store localized data in SQL Server? - Part 4
  1. Why and when we need Knockout.js with help of an example?
  2. What are Bindings in KO? What are different kind of Bindings & how to work with them?
  3. What are & why we need observable property in KO?
  4. What are computed observable in KO?
  1. What is LINQ and can you explain same with example?
  2. Can you explain a simple example of LINQ to SQL?
  3. How can we define relationships using LINQ to SQL?
  4. How can we optimize LINQ relationships queries using ‘DataLoadOptions’?
  5. Can we see a simple example of how we can do CRUD using LINQ to SQL?
  6. How can we call a stored procedure using LINQ?
  7. Source Code for LINQ
  1. Introduction
  2. Validation Application Block
  3. Logging Application Block
  4. Caching Application Block
  5. Security Application Block
  6. Policy Injection Application Block
  7. Exception Handling Application Block
  8. Data Access Layer
  9. Unity Application Block
  10. Source Code
  11. Setup of Enterprise Application Blocks
  1. Introduction
  2. Application Boundary
  3. EI Fundamentals
  4. EO Fundamentals
  5. EQ Fundamentals
  6. EIF Fundamentals
  7. ILF Fundamentals
  8. GSC Fundamentals
  9. Productivity Factor
  10. Costing
  11. Function Point Template
  12. Estimating a Sample Project
  13. Function Point Estimation Excel
  14. Customer Maintenance
  1. SDLC
  2. Estimation
  3. Requirement Technical and Testing
  4. SDLC Source code
  1. Interface
  2. Abstract Classes
  3. Abstraction and Encapsulation
  4. Parent-Child relationship
  5. Aggregation and Composition
  6. Polymorphism
  7. Differences: Interfaces & Abstract Classes
  1. Explain performance counters and perfmon tool?
  2. Finding high memory consuming functions - Part I
  3. Finding high memory consuming functions - Part II
  4. Improve garbage collector performance using finalize/dispose pattern
  5. How to use performance counters to gather performance data - Part 1
  6. How to use performance counters to gather performance data - Part 2
  • Explain performance counters and perfmon tool?
  • Finding high memory consuming functions - Part I
  • Finding high memory consuming functions - Part II
  • Improve garbage collector performance using finalize/dispose pattern
  • How to use performance counters to gather performance data - Part 1
  • How to use performance counters to gather performance data - Part 2
  • How to consume Webservices in Ajax?
    1. What is SOA, Services and Messages (Part 1)?
    2. What is SOA, Services and Messages (Part 2)?
    3. What is the difference between Service and Component?
    4. What are basic steps to create a WCF service (Part I, Creating the Service)?
    5. What are basic steps to create a WCF service (Part II, Consuming the Service)?
    6. What are endpoints, address, contracts and bindings?
    7. What are various ways of hosting WCF service?
    8. What is the difference of hosting a WCF service on IIS and Self hosting?
    9. What is the difference between BasicHttpBinding and WsHttpBinding?
    10. How can we do debugging and tracing in WCF?
    11. Can you explain transactions in WCF (theory)?
    12. Can we see a simple sample of WCF transactions?
    13. How can we self host WCF services ?
    14. What are the different ways of implementing WCF Security?
    15. How can we implement SSL security on WCF(Transport Security)?
    16. How can we implement transport security plus message security in WCF ?
    17. How can we do WCF instancing ?
    18. How Can we do WCF Concurency and throttling?
    19. Can you explain one way & duplex(two way) contract in WCF?
    20. Can you explain one way & duplex(two way) contract in WCF?- Part 2
    21. What exactly is WCF REST service?
    22. What exactly is WCF REST service?-Part 2
    23. What are WCF fault exception?
    24. How to host Multiple endpoint in a single WCF Service?
    25. What is netMSMQBinding in WCF?
    26. Source Code
    1. Section1 - IL Code, JIT, CLR, CTS and CAS
    2. In a parent child relationship which constructor fires first?
    3. What is the difference between i++ & ++i?
    1. What is ADO.NET, Connection, Command & Datareader objects?
    2. What is Dataset and DataAdapter in ADO.NET?
    3. What is ADO.NET Connection Pooling?
    1. Can you explain First, Second & Third Normal forms in database?
    2. What is Denormalization, OLTP and OLAP?
    3. Explain Star Schema & Snow Flake Design?
    4. How does SQL Server store data in 8 KB page?
    5. State 4 different types of SQL join?
    6. What are wild card operators?
    7. Explain Union & Union All?
    8. What is aggregate functions, group by clause, having keyword?
    9. What are subqueries & co-related queries?
    10. What are Indexes and how does it increase performance?
    11. How indexes affect insert, update and delete performance (page split)?
    12. What is the difference between Clustered and Non-Clustered Indexes?
    13. What are triggers, inserted tables and deleted tables?
    14. Can you explain instead of and after triggers with a example?
    15. What are stored procedures and why do we need them?
    16. What is use of ISNULL and Coalesce functions?
    17. What is Row_Number, Partition, Rank and DenseRank?
    18. What is CDC (Change data capture)?
    19. What is the difference between unique key and primary key?
    20. How can we implement Pivot & Unpivot in SQL Server?
    1. HTML 5 and CSS 3 pdf
    1. What is Threading in C#.NET?
    2. How can we make a object thread safe using LOCK in multithreading?
    3. What is Mutex, Semaphore & SemaphoreSlim?
    4. What is AutoResetEvent and ManualResetEvent?
    5. What is Thread Pooling?
    6. How to debug Threads?
    7. What is TPL (Task Parallel Library) and how different it is from threads?
    1. What is IL code, CLR, CLS & JIT? - Part1
    2. What is IL code, CLR, CLS & JIT? - Part2
    3. Explain JIT, Pre-jit, Eco-Jit, Normal-Jit and NGEN.EXE?
    4. What is CAS, evidence, permission set & code groups?
    5. What are the changes in .NET 4.0 security model & What is sandboxing?
    6. What is the difference between managed & unmanaged code?
    7. What is Garbage Collector, Gen 0, 1 & 2?
    8. What is IDisposable interface & finalize dispose pattern in GC?
    9. What is the difference between strong and weak references?
    10. What is delay signing?
    11. Can we see simple example of GAC & How to handle multiple versions in GAC?
    12. What are different .NET datatypes and its uses according to scenarios?
    13. Explain TypeSafe, Casting, Explicit casting & implicit casting?
    14. What is difference between String and string?
    15. What is the difference between String and String Builder?
    16. What problem does Delegate Solve ?
    17. What is a Multicast delegate ?
    18. What are events and what's the difference between delegates and events?
    19. How can we make Asynchronous method calls using delegates ?
    20. What are anonymous methods in C#?
    21. Why anonymous types are preferred over Tuples?
    22. What is the use of Lambda Expression Action<>, Predicate<> & Func<>?
    23. What do you mean by Covariance & Contravariance in .NET 4.0?
    24. What is the use of checked and unchecked keyword?
    25. What is a stack, Heap, Value types and Reference types?
    26. What is boxing and unboxing?
    27. C# Out Vs Ref
    28. What is optimistic and pessimistic locking? - Part1
    29. Can you explain optimistic locking? - Part2
    30. Can you explain pessimistic locking? - Part3
    31. What are regular expressions & can we see some practical demonstrations?
    32. Why do we need Regex timeout (.NET 4.5 feature)?
    33. 5 tips to improve your C# debugging.
    34. Can you explain Named Parameters, Ref, Out, Volatile & Parsetry?
    35. What is the difference between Const & ReadOnly?
    36. Explain the difference between "IS" and "AS" keyword?
    37. What are Extension Methods?
    38. What is #Debug directive?
    39. What is the difference between Debug and Release?
    40. What is serialization and deserialization?
    41. What is the difference between TypeOf and GetType?
    42. What is IComparable and IComparer?
    43. What is the use of Yield Keyword in C#?
    44. What is a C# indexer?
    45. What is the difference between == vs .Equals()?
    46. What are ??(Coalescing operators)?
    47. What is C# reflection?
    48. What is Dynamic keyword & How does it differ from Reflection?
    49. What is the difference between Early binding and Late binding?
    50. What is a difference between VAR and Dynamic keyword?
    51. What is the use of VAR keyword in C#?
    52. What are Circular Dependencies and How to resolve them?
    53. How can we mark a method as deprecated?
    54. What is the difference between Build Vs Rebuild Vs Clean?
    55. What is Naming Convention?
    56. What is Nuget?
    57. What are portable class libraries?
    58. What is Asynch and Await keywords?
    59. What are ENUM's and flags in ENUMS?
    60. How to convert string to ENUM?
    61. How to use MSMQ with C#?
    62. Explain NULLABLE Types?
    63. Explain C# Attributes?
    64. What is AutoMapper?
    65. What are DataAnnotations?
    66. Source Code
    1. What are the different types of collections in .NET?- Part 1
    2. What is the difference between Array & ArrayList?- Part 2
    3. Can you prove why arrays are faster than arraylist?- Part 3
    4. What are the problems with arraylist & how can we solve the same by Hashtables?- Part 4
    5. What are stacks and queues?- Part 5
    6. What are special collections?- Part 6
    7. What are Generics & What are generics collections?- Part 7
    8. What are generics collections?- Part 8
    9. What is the use of IEnumerator, ICollection, IDictionary & IList?- Part 9
    10. What is the difference between IEnumerable and IEnumerator?
    11. Differentiate between IEnumerable vs IQueryTable?
    12. Explain Generics Constraints?
    1. What is the use of Session and Viewstate in ASP.NET?
    2. What is the difference between session & viewstate?
    3. Can you explain ASP.NET application and Page life cycle - (Part 1)?
    4. Can you explain ASP.NET application and Page life cycle - (Part 2)?
    5. Can you explain ASP.NET application and Page life cycle - (Part-3)?
    6. What is a PostBack, IsPostBack and AutoPostBack in ASP.NET?
    7. What is Authentication, Authorization, Principal & Identity objects? Part-1
    8. ASP.NET Authentiication and Authorization Video series Part-2
    9. ASP.NET Authentiication and Authorization Video series Part-3
    10. ASP.NET Authentiication and Authorization Video series Part-4
    11. ASP.NET Authentiication and Authorization Video series Part-5
    12. ASP.NET Authentiication and Authorization Video series Part-6
    13. What are Master pages?
    14. What is Instrumentation, Debugging & Tracing? Part-1
    15. What is Instrumentation, Debugging & Tracing? Part-2
    16. What is Instrumentation, Debugging & Tracing?Part-3
    17. What is Routing in ASP.NET(URL rewriting)?
    18. Server.Transfer VS Response.Redirect
    19. Explain PreserveForm and EndResponse?
    20. Can we have 2 web.config files?
    21. Label Vs Literal
    22. What is Web server and IIS(Internet Information Services)?
    23. ASP.NET page life cycle source code
    1. Lab 1: - Simple Hello world(20 Minutes)
    2. Lab 2: - Explain MVC Routing(10 Minutes)?
    3. Lab 3: - Explain ViewData, ViewBag, TempData & Session Variables?(20 Minutes)
    4. Lab 4: - Explain Model and Strongly typed views (20 minutes)?
    5. Lab5: - Explain Model Binders(10 minutes)?
    6. Lab 6: - Why MVC and MVC vs Webforms?(30 minutes)
    7. Lab 7: - Explain TempData, Peek and Keep?(10 Minutes)
    8. Lab 8: - Explain Data Annotations and HTML Helpers classes?(31 Minutes)
    9. Lab 9: - What is the need of ViewModel in MVC? (10 Minutes)
    10. Lab10: - How can we use Entity Framework in MVC?(20 minutes)
    11. Lab 11: - How to implement viewmodel, partial view and webgrid?(45 minutes)
    12. Lab 12: - What is the difference between ActionResult and ViewResult in MVC?(10 minutes)
    13. Lab 13: - How to implement AJAX using JSON and jQuery using MVC?(60 minutes)
    14. Lab14: - What is the use of Async Controllers in MVC?(20 minutes)
    15. Lab 15: - How to deploy MVC Application on IIS?(10 minutes)
    16. Lab 16: - How can we do Windows and Forms Authentication in MVC?(50 Minutes)
    17. Lab 17: - How can we use MVC areas for better modular development?(10 Minutes)
    18. Lab 18: - How to implement MVC with Angular?(60 minutes)
    19. Lab 19: - Can we Overload MVC Action methods?(10 Minutes)
    20. Lab 20: - How to improve Reusability using Angular?(20 Minutes)
    21. Lab 21: - What is the need of WebAPI in MVC?(30 Minutes)
    22. Lab 22: - How to do exception handling in MVC?(30 Minutes)
    23. Lab 23: - How to do update & delete using MVC, WebAPI, EF & Angular?(30 Minutes)
    24. Lab 24: - How to use MVC Webgrid?(30 minutes)
    25. Lab 25: - How to implement Validation using Angular and MVC?(30 minutes)
    26. Lab 26: - What is SPA (Single page application)?(30 minutes)
    27. Lab 27: - How to Organize MVC project and Understanding CORS issue?(42 minutes)
    28. Lab 28: - Explain the importance of DisplayModes?(10 minutes)
    29. Lab 29: - How to do unit testing with MVC projects?(30 minutes)
    30. Lab 30: - How to implement SPA using Angular Routing)?(20 minutes)
    31. Lab 31: - How to create decoupled systems using MVC DI?(60 minutes)
    32. Lab 32: - How can we have multiple submit buttons in ASP.NET MVC?(13 minutes)
    33. Lab 33: - What is the importance of AntiForgery in MVC?(10 minutes)(10 minutes)
    34. Lab 34: - What is the importance of ValidateInput and AllowHTML in MVC?(10 minutes)
    35. Lab 35: - Bundling and Minification(15 minutes)
    36. Lab 36: - Layout pages in Razor
    37. Lab 37: - What are ActionFilters in MVC?
    38. Lab 38: - What is WebAPI (Theory)?
    39. Lab 39: - How can we create and consume WEB API (Practical)?
    40. Source Code
    1. Introduction
    2. Use Case Diagrams
    3. Class Diagrams
    4. Object Diagrams
    5. Sequence Diagrams
    6. Collaboration Diagrams
    7. Activity Diagram
    8. State chart Diagrams
    9. Component Diagrams
    10. Deployment Diagrams
    11. Stereo Types Diagrams
    12. UML Project Flow
    13. Practice with Tool
    14. Setup
    1. Introduction
    2. Application Boundary
    3. EI Fundamentals
    4. EO Fundamentals
    5. EQ Fundamentals
    6. EIF Fundamentals
    7. ILF Fundamentals
    8. GSC Fundamentals
    9. Productivity Factor
    10. Costing
    11. Function Point Template
    12. Estimating a Sample Project
    13. Function Point Estimation Excel
    14. Customer Maintenance
    1. Scenario 1: - Customer & Logger class Scenario (SRP Violation)
    2. Solution for Scenario 1: - Implementing SRP with factory class & interfaces
    3. Scenario 2: - Add new customer type scenario (OCP violation)
    4. Solution for Scenario 2: - Applying OCP (Open closed principle) by using inheritance
    5. Scenario 3: - The batch printing problem(LSP violation)
    6. Solution for Scenario 3: - Applying LSP (Liskov principle) using interfaces & solving the problem
    7. Scenario 4: - The tax calculator scenario(DI/IOC)
    8. Solution for Scenario 4: - Using unity application using DIIOC
    C Sharp Threading
    1. (Day 1)Lab 1: - Creating your first program
    2. (Day 1)Lab 2: - Creating your first program
    3. (Day 1)Lab 3: - Integer DataType
    4. (Day 1)Lab 4: - Exception Handling
    5. (Day 1)Lab 5: - IF Condition, Return Try/Catch
    6. (Day 2)Lab 6: - Commenting
    7. (Day 2)Lab 7: - For Loop
    8. (Day 2)Lab 8: - Creating a simple calculator program
    9. (Day 3)Lab 9: - Creating your first Windows application
    10. (Day 3)Lab 10: - Creating the Customer Screen
    11. (Day 4)Lab 11: - Displaying Customer Screen
    12. (Day 4)Lab 12: - Multiple Document Interface(MDI)
    13. (Day 5)Lab 13: - Classes & Objects
    14. (Day 6)Lab 14: - Getting Data from SQL Server
    15. (Day 7)Lab 15: - Inserting data into SQL Server
    16. (Day 7) Lab 16: - Storing connection string in App.config files
    17. (Day 8) Lab 17: - Delete Functionality
    18. (Day 9) Lab 18: - Update Functionality
    19. (Day 9) Lab 19: - 2 Tier Architecture
    20. (Day 10) Lab 20: - Creating a web application
    21. (Day 10) Lab 21: - Connect WebApp to Data Access Layer
    22. (Day 11 & 12) Lab 22: - Implementing Insert, Update & Delete
    23. (Day 13) Lab 23: - Implementing 3 Tier Architecture
    24. (Day 14) Lab 24: - Security
    25. (Day 15) Lab 25: - Web Security
    26. (Day 16) Lab 26: - REGEX
    27. (Day 17) Lab 27: - Improving Database Design
    28. (Day 18)Lab 28: - 1 to many relationship
    29. (Day 19)Lab 29: - 1 to Many(Insert)
    30. (Day 20)Lab 30: - 1 to Many(Select & Delete)
    31. (Day 21)Lab 31: - 1 to Many(Update)
    32. (Day 22)Lab 32: - Stored Procedure
    33. (Day 23)Lab 33: - Reusability
    34. (Day 24)Lab 34: - Application and Cache in ASP.NET
    35. (Day 25)Lab 35: - Sessions in ASP.NET
    36. Day 26 to Day 60: - Project
    37. Source Code
    VSTS Testing
    Videos List
    1. What is the problem with Functional Programming?
    2. Can you define OOP and the 4 principles of OOP?
    3. What are Classes and Objects?
    4. What is Inheritance?
    5. What is Polymorphism, overloading, overriding and virtual?
    6. Can you explain encapsulation and abstraction?
    7. What is an abstract class?
    8. Define Interface & What is the diff. between abstract & interface?
    9. Define Interface & Diff. between abstract & interface? - Part 2
    10. What is Shadowing?
    11. Can we implement interfaces with same method names in C#?
    12. What is the use of Static Keyword?
    13. What is the difference between Abstraction and Encapsulation?
    14. What are partial classes & partial methods?
    15. Can we see implementation of Association, Aggregation & Composition in real world?
    16. What is operator overloading?
    17. Explain Access modifiers (Private, Public, Protected, Internal & Protected/Internal)?
    18. Source Code
    Learn Angular JS
    Javascript Framework
    1. Lab 1: - Design pattern step by step with a project(Factory pattern,Lazy Pattern and RIP Pattern).(60 minutes)
    2. Lab 2: - Unity, Stratergy, IOC, SRP and SOC.(30 minutes)
    3. Lab 3: - Template pattern and Repository pattern with ADO.NET.(60 minutes)
    4. Lab 4: - Adapter Pattern and Repository with EF(60 minutes)
    5. Lab 5: - UOW(Unit of Work)(30 minutes)
    6. Lab 6: - Decorator Pattern(30 Minutes)
    7. Lab 7: - Iterator Pattern(25 Minutes)
    8. Lab 8: - Prototype and Memento Pattern(25 Minutes)
    9. Lab 9:- Implementing complex object creation using Factory Method(1 Hour)
    10. Explain SOLID?
    11. Introduction
    12. Factory Pattern
    13. Abstract Factory Pattern
    14. Builder Pattern
    15. Prototype Pattern
    16. Singleton Pattern
    17. Adapter Pattern
    18. Bridge Pattern
    19. Composite Pattern
    20. Decorator Pattern
    21. Facade Pattern
    22. Flyweight Pattern
    23. Proxy Pattern
    24. Mediator Pattern
    25. Memento Pattern
    26. Interpreter Pattern
    27. Iterator Pattern
    28. COR Pattern
    29. Command Pattern
    30. State Pattern
    31. Strategy Pattern
    32. Observer Pattern
    33. Template Pattern
    34. Visitor Pattern
    35. Explain IOC(Inversion of Control)?
    36. Dependency Injection
    37. Fluent interface and method chaining
    38. Lazy Loading
    39. Explain RIP(Replace IF with Polymorphism) Pattern?
    40. Immutable Object Design Pattern
    41. Explain Null Design Pattern and its usage.
    42. Source Code
    1. What is Entity Framework (Theory)?
    2. Lab 1: - What is EDMX, Context and Models in EF?
    3. Lab 2: - How to read,insert, update & delete data using EF (Entity framework)?
    4. Lab 3: - How to insert custom business validation in Entity classes?
    5. Lab 4: - What are POCO Classes?
    6. Lab 5: - How to implement code first?
    7. Lab 6: - How to solve concurrency issues in EF(Optimistic locking)?
    8. Lab 7: - What is Clientwins and StoreWins in Entity framework?