Thursday, February 24, 2011

Reportviewer print - blank pages

If a blank page is inserted after printing each page of a report (created with the Reportviewer control in Visual Studio 2010), narrow the width of the report in .rdlc file.

Friday, February 18, 2011

Learning stored procedures

Advantages of sp:
- capable of handling very complex queries
- utilizes resources of the db server not the app server
- convenient for moving app from platfrom to platform - business logic stays with the db

Sp structure:
CREATE PROCEDURE [PROCEDURE NAME]

/*
variables:
@variableName type
*/

AS

/*
SQL statements
*/

Wednesday, February 16, 2011

What is ADO .NET Entity Framework

- a set of data access APIs
- targeting ADO .NET 4.0
- EFv4 (2nd edition) shipped with .NET 4.0 and VS 2010
- Entity Data Model is treated indepenently from its underlying datastore

WHAT IS LINQ??

- stands for Language Integrated Query
- able to query objects, ADO .NET (dataset, database, entities), XML

LINQ - http://msdn.microsoft.com/en-us/magazine/cc337893.aspx

LINQ to Entities - http://www.linqdev.com/PublicPortal/publicportal/linq-to-entities.aspx