Category Archives: Database

Database

What is the best way to paginate results in SQL Server

What is the best way (performance wise) to paginate results in SQL Server 2000, 2005, 2008, 2012 if you also want to get the total number of results (before paginating)? Getting the total number of results and paginating are two … Continue reading

Posted in C#, Database, Knowledge, Problem solving, Programming, Uncategorized | Leave a comment

All About TransactionScope

1. Introduction TransactionScope is a very special and important class in the .NET Framework. Supporting transactions from a code block is the main responsibility of this class. We often use this class for managing local as well as distributed transactions from … Continue reading

Posted in ASP.NET MVC, C#, Database, Uncategorized | Leave a comment

Moq – Mock Database

Introduction Moq is a very useful framework which easily mocks service calls and methods for your unit testing. This article helps you to understand Moq with respect to mocking a database (i.e. writing unit test cases for your repository project). … Continue reading

Posted in ASP.NET MVC, C#, Database, Uncategorized | Leave a comment

A Comparison of the Top Four Enterprise-Architecture Methodologies

Nguồn Microsoft A Comparison of the Top Four Enterprise-Architecture Methodologies Roger Sessions ObjectWatch, Inc. May 2007 Applies to: Enterprise Architecture Summary: Twenty years ago, a new field was born that soon came to be known as enterprise architecture. This paper … Continue reading

Posted in ASP.NET MVC, C#, Database, Software architecture | Leave a comment

Entity Attribute Value sample

This guide is intended to help programmers and DBA’s understand the considerations and consequences associated with an EAV schema and to provide a basic framework for its implementation in SQL Server (>= 2000). It is based on the idea that … Continue reading

Posted in Business Model, Database | Leave a comment

Entity Attribute Value model

Throughout my software development career, I’ve seen my fair share of debates over how databases should be developed. And like most disagreements over technical pedantry, the participants are generally well-intentioned but grossly inexperienced. So much so that it wouldn’t matter … Continue reading

Posted in Business Model, Database | Leave a comment

SQL SERVER – The Self Join – Inner Join and Outer Join

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and … Continue reading

Posted in Business Model, Database | Leave a comment