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
*/
- 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
- 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
Tuesday, February 15, 2011
Subscribe to:
Posts (Atom)