Archives for Software Dev - Page 46
Filesystem notes from the real world–C#
These are just some quick tidbits about file processing in C#. Reading in files, reading in LARGE files, Reading and Processing Large Files. Reading a file (use a StreamReader) if…
Custom authentication filter in ASP.NET MVC
First, I approached this by trying to implement the IAuthorizationFilter interface. THis provides an OnAuthorization method that can be implemented for your custom authentication (see example below). However, as I…
Overall Strategy for Monitoring SQL Server Performance
This is just a quick cliff’s notes on what to look for in terms of the Physical Design of the database. The four main categories of concern are : Memory…
Nasty Joins, Cartesian Joins
A Cartesian join is an (incorrect) join between two tables. Incorrect because the tables have not been joined in any relational street_address from authors a, location b where like ‘%varma%’…
Inheriting an existing Entity Framework Implementation
Several quirks may pop up – the project may not work seamlessly in your local environment. Entity Framework generates a slew of files – most notably its mapping file (with…
Entity Framework–where to put the data folder
In your folder structure, where shoul you put the edmx data folder? As all EDMX files are representations (abstractions) of some relational database, they belong in the Models folder. The…
Always build a services tier (layer) even if you don’t think you may need it
There is a lot of debate on the prevalence of the service layer (web services tier) – in almost every app (web or non web) built today. Martin Fowler also…
IE compatibility testing–Internet explorer
I tried various tools including IE developer tools (in IE 11) – and IE Tester. These are all desktop based – and require software downloads and local testing. Someone pointed…
IIS app pool using 4.5 framework
Is your web app (deployed on IIS) using framework ? How do you tell?Just looking at the framework column (for the specific app pool) in IIS will show you (since…
Sql Server Enterprise versus Standard Editions
High Availability SQL Server Standard includes some features to enable high availability, but the Enterprise edition brings more. Features like database snapshots, mirrored backups and fast restore mean that when…