Category Archives: Database

Database

Teaching Tools

Online tools and resources have made it easier for teachers to instruct students, and for students to collaborate with those teachers and with other students and parents. These “Web 2.0” teaching tools aren’t magical, but they may seem to defy … Continue reading

Posted in Database, Education and Training, Knowledge, Problem solving, Programming, Uncategorized | Leave a comment

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