--- title: "Three free recipes from \"ADO.NET Cookbook\"" url: "https://osherove.com/blog/2004/1/16/three-free-recipes-from-quotadonet-cookbookquot.md" canonical: "https://osherove.com/blog/2004/1/16/three-free-recipes-from-quotadonet-cookbookquot.html" published: "2004-01-16T22:51:00" updated: "2004-01-16T22:51:00" tags: [".Net Original", "Free book chapters"] author: "Roy Osherove" description: "[ .NetWire :] \" O'Reilly's recently released ADO.NET Cookbook contains over 150 solutions and best practices for everyday dilemmas. This week, we're excerpting three recipes from the book that show how to asynchronously…" usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)." license: "https://creativecommons.org/licenses/by/4.0/" --- # Three free recipes from "ADO.NET Cookbook" By Roy Osherove January 16, 2004 In [.Net Original](https://osherove.com/blog/category/net-original), [Free book chapters](https://osherove.com/blog/category/free-book-chapters) **Historical article** · Originally published January 16, 2004; technical details may be outdated. \[[.NetWire](http://www.dotnetwire.com/):\] "_O'Reilly's recently released ADO.NET Cookbook contains over 150 solutions and best practices for everyday dilemmas. This week, we're excerpting **three recipes from the book** that show how to [asynchronously update data in a database](http://www.ondotnet.com/pub/a/dotnet/excerpt/ado.netckbk_chap01/index.html), how to [protect login credentials during network transmissions](http://www.ondotnet.com/pub/a/dotnet/excerpt/ado.netckbk_chap01/index.html?page=2), and how to [enforce a business rule with column expressions](http://www.ondotnet.com/pub/a/dotnet/excerpt/ado.netckbk_chap01/index.html?page=3)"_ God I love free information. Ain't it just fun to look at a page\\book and think to yourself, "_After I read this block of text I will have gained another ounce of knowledge_"? The other day I came across the book "[Computer Organization and Architecture: Designing for Performance](https://www.amazon.com/exec/obidos/ASIN/013359985x/iserializable-20)" by William Stallings. How I came across it? it was lying there on my employer's shelf. I was never any kind of hardware guy. Sure, I can detach a CD ROM but I have no idea how a CPU works and although I tried mastering [Assembly language](http://webster.cs.ucr.edu/Page_AoAWin/HTML/AoATOC.html)  I never did get to a point I "got" it. Anyway, I was looking for something interesting to read when I came across this book. I opened it and started leafing through the pages. I could read the names of the chapter titles, I could see the complex diagrams, but, much like a little boy looking at a world atlas for the first time, all I could do was look with big eyes at all the information my brain just can't contain at this moment. It was one of those times, when I got that feeling; "_I'm holding a whole lot of knowledge in my hands right now. If I could just concentrate enough I could transfer it into my brain"_. But all I could do was continue leafing through the chapters, one by one, getting more and more amazed at the amount of complexity that lies in the machine I am using every day. It is truly an amazing piece of work. The complexity and the size of the indirection to which humans have come to in this machine in almost godly, yet we scream for more. Smaller, faster,sharper. We have no idea just how amazing all this already is. But I digress :) ## More in .Net Original [All posts in .Net Original](https://osherove.com/blog/category/net-original) - Jan 17, 2004 ### [Learning from mistakes: the Don Quixote pattern](https://osherove.com/blog/2004/1/17/learning-from-mistakes-the-don-quixote-pattern-1.html) - Jan 17, 2004 ### [Using SOA on existing N-tier applications](https://osherove.com/blog/2004/1/17/using-soa-on-existing-n-tier-applications.html) - Jan 10, 2004 ### [Service announcement: Source code for MSDN articles now available](https://osherove.com/blog/2004/1/10/service-announcement-source-code-for-msdn-articles-now-avail.html) - Jan 10, 2004 ### [New MSDN article: Turn Your Log Files into Searchable Data Using Regex and the XML Classes](https://osherove.com/blog/2004/1/10/new-msdn-article-turn-your-log-files-into-searchable-data-us.html) --- ## About the author **Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery. ### Sites - [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership. - [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts. - [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin. - [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model. - [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps. - [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes). ### Social - X: https://x.com/royosherove - LinkedIn: https://www.linkedin.com/in/osherove/ ### Contact - Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7 ### License Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/