Tag Archives: Database

Managing BLOBs using SQL Server FileStream via EF and WCF streaming

Posted on February 20, 2012 by

Für mehr Informationen zu diesem Thema in Deutsch siehe meinen Artikel “Stream das BLOB” im dotnetpro Magazin 6/2012. With FileStream SQL Server 2008+ stores BLOBs in the NTFS file system instead of its table store and offers fast streaming access. … Continue reading →

Posted in Computers and Internet | Tagged , , , , , , | 4 Comments

Using Transactional NTFS (TxF) with SQL Server in .NET

Posted on February 19, 2012 by

I just stumbled across the very new Transactional NTFS (TxF) .NET managed wrapper by Pietro Partescano and gave it a try. TxF offers transactional protection for NTFS operations: Atomic operations on single files. Makes writing files more robust. Transactions for … Continue reading →

Posted in Computers and Internet | Tagged , , , , | Leave a comment

.NET Database Access Options

Posted on April 10, 2011 by

Database access options in .NET: Plain ADO.NET and DataSets See The SQLCommandBuilder is way Better than its Reputation. Create a custom simple ADO.NET data access wrapper Provider independent using System.Data.Common Microsoft Enterprise Library, Data Access Application Block (DAAB) Can be used … Continue reading →

Posted in Computers and Internet | Tagged , , , , , , , | Leave a comment

My Advice for .NET Application Architecture and Design

Posted on April 10, 2011 by

This post summarizes my general architecture and design guidelines for developing applications and points to some interesting NET technologies. Reading this post will not make anyone an architect, but working through it should give you a good foundation for understanding … Continue reading →

Posted in Computers and Internet | Tagged , , , , , , , , | 1 Comment

How to Configure MS SQL Server for Testing with Visual Studio

Posted on March 20, 2011 by

When setting up MS SQL Server for test projects with Visual Studio I generally  stumble across the following problems only: Use SQL Server Express or Developer Edition? Enabling remote access What are the default database instance names With Oracle I … Continue reading →

Posted in Computers and Internet | Tagged , , , | Leave a comment

How to Configure Oracle for Testing with Visual Studio

Posted on March 20, 2011 by

Every time I was setting up Oracle for testing (without having a DBA around) I got stuck somewhere and wasted a lot of time troubleshooting – even started to dislike Oracle for that. With MS SQL Server I have less … Continue reading →

Posted in Computers and Internet | Tagged , , , | 3 Comments

DB Concurrency Control with .NET – Details

Posted on March 14, 2011 by

[To put this post into perspective see DB Concurrency Control with .NET - Overview] The following patterns are commonly used in applications to control database concurrency: Optimistic Control in UI Scenarios in Service Scenarios Pessimistic Control SQL Locking Hints Check-out Locking … Continue reading →

Posted in Computers and Internet | Tagged , , , , , , , , , , | 3 Comments

Know your Database System!

Posted on March 14, 2011 by

[To put this post into perspective see DB Concurrency Control with .NET - Overview] Developing database centric applications you must(!) understand the fundamentals of your specific database management system – even when using an ORM: You must understand the DBMS architecture … Continue reading →

Posted in Computers and Internet | Tagged , , , , , , | 3 Comments

The SQLCommandBuilder is way Better than its Reputation

Posted on March 13, 2011 by

There has always been a lot of criticism about the DBCommandbuilder (ex: Weaning Developers from the CommandBuilder). However, if you know its limitations, there are many scenarios where the DBCommandbuilder is quite useful, like: Managing lookup tables Single-table updates Prototyping … Continue reading →

Posted in Computers and Internet | Tagged , , | 2 Comments

Beware of End-User Permissions in Databases

Posted on March 13, 2011 by

Beware of giving end users direct access to your databases, e.g. by using SQL Server integrated security in single-layer or Client/Server architectures. If end users have permissions on database tables they may bypass your application logic and read or update … Continue reading →

Posted in Computers and Internet | Tagged , , , , , | Leave a comment