Entity Framework Interview Question – Explain ENUM usage in EF5

Entity Framework 5 introduced support for Enum’s amongst other new features. This was a long awaited feature by the community.To learn how enums work with entity framework, how can you code them, how to use them, how they are represented in the database, head over to my Explain ENUM usage in EF5 on my programming…


Entity Framework – what are the different ways to configure database name?

Entity Framework allows you to create a model (either using code-first approach or modeling tools) which can target an existing database or create a new one. So what are the different ways you can use to configure which database to use? How to name it? Read my blog post on my programming interviews blog to…


How to populate a database table with text from a file

Learn about loading text from a file into a database table on my latest blog post on SQL read text from a file at my programming interviews blog (Direct link: http://www.programminginterviews.info/2013/03/sql-read-text-from-file.html )


SQL self join or sub-query interview question (employee-manager salary)

One of my favorite interview questions that tips even seasoned SQL guys (maybe because it’s too simple) is around querying data that involves a self join. Question: Given an Employee table which has 3 fields – Id (Primary key), Salary and Manager Id, where manager id is the id of the employee that manages the…


Advanced programming interview questions and answers

Here is a refresh of my posts on advanced programming interview questions and answers   Lost in a Forest of Trees The Ins and Outs of a Binary Search Tree Simple Patterns: Singleton Pattern Simple Patterns: Repository Pattern Simple Patterns: Factory Pattern Implement a basic Stack using linked List Implement a Queue data structure using…


Data migration strategies and design patterns

Data migration is an extremely common operation in software design and development. Whenever a new system is introduced or a legacy system is redesigned, existing data has to be moved from the legacy system to the new target system. Learn more at Data migration strategies and design patterns on my programming interviews blog.