https://www.developerfusion.com/t/ado.net/ Latest ADO.NET developer content from Developer Fusion http://www.rssboard.org/rss-specification en-GB Tue, 19 Jul 2011 11:04:28 GMT In the age of Object Relational Mapping frameworks (ORMs) it seems unusual to ever get 'close to the metal' when it comes to persisting data. However, when you need to squeeze the last ounce of performance out of your app - it can make sense to go under the covers. http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/ http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/ Tue, 19 Jul 2011 11:04:28 GMT Mike Goatly This is a self-paced, professional book that shows how to use Visual Studio 2010, C# 2010, and the .NET 4 classes to develop Windows Forms applications. It's an object-oriented book that shows how to use business classes, inheritance, and interfaces the way they're used in the real world. It's a database programming book that shows how to prototype professional database applications using RAD features like data sources, as well as how to start using ADO. http://www.developerfusion.com/book/89809/murachs-c-2010/ http://www.developerfusion.com/book/89809/murachs-c-2010/ Tue, 22 Feb 2011 12:48:58 GMT Joel Murach Joydip Kanjilal looks at the problems caused by concurrency when accessing data, both online and offline, and how to overcome them. http://www.developerfusion.com/article/84418/concurrency-handling-techniques-in-adonet/ http://www.developerfusion.com/article/84418/concurrency-handling-techniques-in-adonet/ Tue, 22 Feb 2011 12:48:53 GMT Joydip Kanjilal In-depth coverage of Microsoft's new programming language-F# 2010F# is a new programming language from Microsoft, a fusion of object-oriented and functional approaches, which offers a number of new features and approaches to making software easier to write. Supported for the first time with Visual Studio 2010, F# is particularly ideal for software that needs to take full advantage of multicore processors, and this comprehensive book covers all aspects of this functional language. http://www.developerfusion.com/book/82969/professional-f-10/ http://www.developerfusion.com/book/82969/professional-f-10/ Tue, 22 Feb 2011 12:48:53 GMT Ted Neward, Aaron Erickson, Talbott Crowell, Rick Minerich Craig reviews IronPython In Action by Michael Foord and Christian Muirhead http://www.developerfusion.com/review/83506/ironpython-in-action/ http://www.developerfusion.com/review/83506/ironpython-in-action/ Tue, 22 Feb 2011 12:48:52 GMT Craig Murphy Beginning XML with C# 2008 focuses on XML and how it is used within .NET 3.5. As you’d expect of a modern application framework, .NET 3.5 has extensive support for XML in everything from data access to configuration, from raw parsing to code documentation. This book demystifies all of this. It explains the basics of XML as well as the namespaces and objects you need to know in order to work efficiently with XML. http://www.developerfusion.com/book/17128/beginning-xml-with-c-2008-from-novice-to-professional/ http://www.developerfusion.com/book/17128/beginning-xml-with-c-2008-from-novice-to-professional/ Tue, 22 Feb 2011 12:48:52 GMT Bipin Joshi Entity Framework finally makes it out the door http://www.developerfusion.com/news/7882/visual-studio-2008-sp1-released/ http://www.developerfusion.com/news/7882/visual-studio-2008-sp1-released/ Tue, 22 Feb 2011 12:48:51 GMT James Crowley Learn about the most important features of ADO.NET 2.0 for you! Catch up with Craig Shoemaker and Wally McClure as they discuss the 'evolution' in ADO, not the 'revolution' in the framework. http://www.developerfusion.com/media/8527/adonet-20-interview-with-wally-mcclure/ http://www.developerfusion.com/media/8527/adonet-20-interview-with-wally-mcclure/ Wed, 09 Feb 2011 18:07:47 GMT James Crowley This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly. http://www.developerfusion.com/code/5445/sql-data-provider-vbnet-class/ http://www.developerfusion.com/code/5445/sql-data-provider-vbnet-class/ Wed, 09 Feb 2011 18:07:45 GMT This article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices. http://www.developerfusion.com/article/5385/highperformance-net-application-development-architecture/ http://www.developerfusion.com/article/5385/highperformance-net-application-development-architecture/ Wed, 09 Feb 2011 18:07:45 GMT Dimitrios Markatos This article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version! http://www.developerfusion.com/article/5292/datagridgridview-paging-and-sorting-using-a-datareader/ http://www.developerfusion.com/article/5292/datagridgridview-paging-and-sorting-using-a-datareader/ Wed, 09 Feb 2011 18:07:45 GMT Dimitrios Markatos One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace. http://www.developerfusion.com/code/5282/transactions-made-easy-with-net-20/ http://www.developerfusion.com/code/5282/transactions-made-easy-with-net-20/ Wed, 09 Feb 2011 18:07:45 GMT Xavier Larrea ADO.NET 2 has new classes that makes it quite easy to write data-programs independent of the database engine. Learn how here. http://www.developerfusion.com/code/5264/database-independent-adonet-20/ http://www.developerfusion.com/code/5264/database-independent-adonet-20/ Wed, 09 Feb 2011 18:07:45 GMT Xavier Larrea In this article, we will examine how to create a fully functional DataGrid and GridView in .NET 2.0 with all the features you'd find set up on Hotmail, Yahoo, and AOL Mail, and further demonstrate how you can multi-select items across pages and batch delete them all. http://www.developerfusion.com/article/5258/selecting-confirming-deleting-multiple-checkbox-items-in-a-datagridgridview-part-2-maintaining-checkbox-state-acr/ http://www.developerfusion.com/article/5258/selecting-confirming-deleting-multiple-checkbox-items-in-a-datagridgridview-part-2-maintaining-checkbox-state-acr/ Wed, 09 Feb 2011 18:07:44 GMT Dimitrios Markatos ADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data. http://www.developerfusion.com/article/4703/filtering-and-sorting-in-adonet/ http://www.developerfusion.com/article/4703/filtering-and-sorting-in-adonet/ Wed, 09 Feb 2011 18:07:44 GMT Martin Zahn You can save code by piling SQL statements into one SqlCommand and then getting a DataReader with multiple result sets. http://www.developerfusion.com/code/4638/how-to-run-through-multiple-datareader-results/ http://www.developerfusion.com/code/4638/how-to-run-through-multiple-datareader-results/ Wed, 09 Feb 2011 18:07:44 GMT Edward Tanguay Demonstrates how to connect to a MySQL database with C#. http://www.developerfusion.com/code/4596/how-to-access-a-mysql-database-with-net/ http://www.developerfusion.com/code/4596/how-to-access-a-mysql-database-with-net/ Wed, 09 Feb 2011 18:07:43 GMT Edward Tanguay An extensive examination of using ADO.NET to access SQL Server databases, from establishing connections and executing stored procedures, to connection pools, data readers and data sets. http://www.developerfusion.com/article/4278/using-adonet-with-sql-server/ http://www.developerfusion.com/article/4278/using-adonet-with-sql-server/ Wed, 09 Feb 2011 18:07:43 GMT James Crowley In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET. In particular, with this article we will cover ASP.NET server controls, ADO.NET DataSource, and creating Templated DataBound Controls, ASP.NET forms, using data with controls. John Godel http://www.developerfusion.com/article/4410/in-depth-aspnet-using-adonet/ http://www.developerfusion.com/article/4410/in-depth-aspnet-using-adonet/ Wed, 09 Feb 2011 18:07:43 GMT John Godel This code shows you how to delete records with an SQL statement and get the number of records deleted returned back as an integer. http://www.developerfusion.com/code/4391/how-to-delete-records-with-sqlcommand/ http://www.developerfusion.com/code/4391/how-to-delete-records-with-sqlcommand/ Wed, 09 Feb 2011 18:07:43 GMT Edward Tanguay