Tag Cloud
.NET ADO.NET Architecture Calendar Client/Server Cloud Contacts Database Dataflow Dev_Workstation Distributed_Apps Email Entity_Framework FileSystemWatcher Gmail InternalBufferOverflowExceptions Kindle LightSwitch Notebook Office_365 OneDrive Oracle Outlook Project_Management remember_the_milk Security Server_2008 SQL_Server Surface Tasks ThinkPad TPL Transaction_Scope Travel UWP Visual_Studio WCF Windows 10 Windows_7 Windows_8 Windows_Phone-
Recent Posts
- Global Error Handling for UWP-Apps
- Tracing for UWP-Apps
- Quirks with date and number formats in UWP Apps and Windows 10
- Good Gear and Tools for Digital Nomads (with DE shopping links)
- Good Gear and Tools for Digital Nomads (with UK shopping links)
- Good Gear and Tools for Digital Nomads (with US shopping links)
- Thoughts and Experiments on Cloud Encryption
- How to completely clean install Windows 10 on a UEFI PC
- Windows Service Worker Options
- Simple WCF
- Tamed FileSystemWatcher
- My Windows 8.1 upgrade and usage experiences
- How to move from Hotmail and Gmail to Office 365 as a Server for Outlook desktop and Windows Phone 8
- Installing Windows 8 on an old X61s ThinkPad
- A WebCrawler demonstrating the Beauty of TPL Dataflow
- WP7 Background Agent Pitfalls and App/Agent Synchronization
- Windows Phone 7 App Development Helpers and Time Savers
- Managing BLOBs using SQL Server FileStream via EF and WCF streaming
- Using Transactional NTFS (TxF) with SQL Server in .NET
- How to get the best currency exchange rate when travelling
- Changing the email send address in Office 365 without moving your domain
- Using Native VHD Boot
- My Advice for Successful Projects
- Have Passion for Your Work
- .NET Database Access Options
- My Advice for .NET Application Architecture and Design
- Advanced Search with Internet Search Engines
- Why I Dislike IE 9
- Configure your Kindle for better Readability
- About Opinions and Assumptions
Archives
- July 2016 (2)
- June 2016 (1)
- April 2016 (3)
- March 2016 (1)
- September 2015 (1)
- June 2015 (2)
- May 2015 (1)
- October 2013 (1)
- April 2013 (1)
- October 2012 (2)
- May 2012 (2)
- February 2012 (2)
- October 2011 (1)
- July 2011 (1)
- April 2011 (5)
- March 2011 (15)
- January 2011 (1)
- March 2010 (3)
Meta
Tag Archives: Transaction_Scope
Managing BLOBs using SQL Server FileStream via EF and WCF streaming
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 .NET, ADO.NET, Architecture, Database, Entity_Framework, SQL_Server, Transaction_Scope
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 .NET, ADO.NET, Architecture, Client/Server, Database, Distributed_Apps, Entity_Framework, LightSwitch, Oracle, SQL_Server, Transaction_Scope
3 Comments
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 … Continue reading
Posted in Computers and Internet
Tagged .NET, ADO.NET, Database, Entity_Framework, Oracle, SQL_Server, Transaction_Scope
4 Comments
Avoid unwanted Escalation to Distributed Transactions
[editing in progress!] 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 … Continue reading
Posted in Computers and Internet
Tagged .NET, ADO.NET, Database, Entity_Framework, Oracle, SQL_Server, Transaction_Scope
8 Comments
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 .NET, ADO.NET, Architecture, Client/Server, Database, Distributed_Apps, Entity_Framework, Oracle, SQL_Server, Transaction_Scope
3 Comments
