I’ve been using LINQ to SQL for quite sometime because until recently I’ve had little need for Entity Framework’s EDMX mappings because we’ve generally been content with one-to-one table to entity mappings that LINQ to SQL gives us. However, with the addition of a new module to our project that is close, but not quite … More Getting to know Entity Framework – Table Per Type (TPT) Inheritance
A recent discovery of a “feature” in Microsoft Reporting Services reports is that when you toggle visibility for a report element, for example, a table inside a rectangle, then you’ll find that paging on that element no longer works. This is exactly what happened in a recent report where I toggled visibility of the grid … More Gotcha – Reporting Services reports won’t page any more
One of the most irritating features I initially found when using LINQ to SQL diagrams was the all or nothing approach for managing tables and views in a way that allows quick regeneration after database schema changes. Out of the box (VS2008 pre-SP1) you have two options: Build LINQ to SQL dbml mapping files by … More Filter tables and rename associations generated by SqlMetal using Powershell
Recently while installing SQL Server 2005 Standard Edition on a “fresh” server I found that crazy thing just wouldn’t install! I was getting the following error: “An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package ‘sqlncli.msi’” Most cryptic… … More Error while installing SQL Server 2005 – Native Client cannot be found
From: http://blogs.ssw.com.au/andrewweaver/archive/2005/03/11/3968.aspx Its a frequent situation where you want your ASP.NET application to connect to the SQL Server using the integrated security account. For example, you have all of your roles setup on the SQL Server and want your web application (secured via IIS integrated authentication) to get data specific to your role on the … More Archive: ASP.NET impersonation and SQL Server
Update – 2 May 2008 – Watch out for SQL Server 2008’s new Date and Time data types! From: http://blogs.ssw.com.au/andrewweaver/archive/2006/06/19/8262.aspx Something that comes up quite frequently when dealing with reporting and DateTime fields on a data table is grouping by the Date portion only of the field or filtering for a full day of data. … More Archive: Getting the Date portion of a DateTime type in SQL (T-SQL) – Use Floats and Floor!