Tag Archives: Distributed_Apps

Simple WCF

[Für Details siehe meinen kommenden Artikel “WCF Leicht und robust” im dotnetpro Magazin 1/2016.] Choosing WCF options and configuring them can be quite cumbersome and demanding. This post shares a very simple approach for using WCF services. Download complete code. … Continue reading

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

.NET Database Access Options

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

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 , , , , , , , , | 4 Comments

DB Concurrency Control with .NET – Details

[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

Beware of End-User Permissions in Databases

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

DB Concurrency Control with .NET – Overview

This (long) posting provides guidelines for using common patterns to control concurrency when using relational databases (RDBMS) via ADO.NET or the .NET Entity Framework (EF). MS SQL Server and Oracle are used as examples to sensitize you for the implications … Continue reading

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