Archives for Software Dev - Page 46
The quickest way to compare two lists (for matching entries–i.e. duplicates)
In Excel (2007 and above), place each list of values in its own column. Now, Select cells in first list, then hold CTRL key and then select the second Go…
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…