Schlagwort-Archive: Oracle

.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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , , | Kommentar hinterlassen

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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , , , | 4 Kommentare

How to Configure Oracle for Testing with Visual Studio

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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , | 3 Kommentare

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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , , , , , | 3 Kommentare

Know your Database System!

[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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , | 3 Kommentare

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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , | Kommentar hinterlassen

Stored Procedures Pros & Cons

Using a stored procedures (SP) data access layer is a totally viable approach (see [1]). While I do not devalue SP’s as the „assembly language of databases“, I personally dislike the language break and generally use stored procedure in special … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , | 2 Kommentare

Use the .NET TransactionScope

The TransactionScope class provides an elegant way to enclose a set of operations against resource managers in a transaction. Resource managers are: Databases (SQL Server, Oracle, DB2, …) MSMQ Transactional NTFS file system TxF Transactional Registry Custom resource managers See … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , | 4 Kommentare

Avoid unwanted Escalation to Distributed Transactions

When working with the .NET TransactionScope we want to use simple, lightweight, (local) transactions and avoid  escalating to distributed transactions if possible. This is not a problem when using SQL Server 2008+ and not nesting connections but if you are … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , | 12 Kommentare

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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , , , , | 3 Kommentare