Category Archives for Data Access Class
Record count of all tables in sql server
This query will take a second to get the rows count from all table. I feel must create a view of this query. SELECT ‘[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']‘ AS fulltable_name , SCHEMA_NAME(t.schema_id) AS schema_name , t.name AS tablename ,i.rows As DataCount FROM sys.tables AS t INNER JOIN sys.sysindexes AS i ON t.object_id = i.id … Continue reading
How to Create Data Access Class
As a software developer our lives revolve around working with data. We create databases to store the data, code to retrieve and modify it. and input interfaces to collect and summarize it. Most of the database applications architecture compose of a Data Access Layer (DAL) using typed data-set, Buisness logic layer (BLL) that organizes custom business rules and Presentation layer … Continue reading