|
|
|
|
|
Total Hits: 154 | Today: 0
|
Author: Jayaram Krishnaswamy
|
Rating:
|
|
The provider factory object in ADO.NET 2.0 lets you create commands for data that are independent of the database in which it is stored. If you want to learn more about this very useful item, keep reading.
Different database products have different providers. If the connection string and the provider can be disassociated, then the provider information can be stored in a central location such as the Machine.config file. This came into being with ADO.NET 2.0. Since there are many providers (MS ...
|
|
|
|
Total Hits: 148 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
As Web developers, our lives revolve around working with data. We create databases to store the data, code to retrieve and modify it, and web pages to collect and summarize it. This is the first tutorial in a lengthy series that will explore techniques for implementing these common patterns in ASP.NET 2.0. We'll start with creating a software architecture composed of a Data Access Layer (DAL) using Typed DataSets, a Business Logic Layer (BLL) that enforces custom business rules, and a presentati...
|
|
|
|
Total Hits: 50 | Today: 0
|
Author: Luis Ramirez.
|
Rating:
|
|
The ASP.NET 2.0 framework has a very good control, the SqlDataSource control. Without write a single line of code you can insert, update, delete and select data. The bad point is that it mixes the presentation layer and the data access layer. It means, the SqlDataSource control embeds the SQL code into your presentation layer. That is the reason that makes many people to choose another options such as: ObjectDataSource control or create their own classes for the data access layer. Here there is...
|
|
|
|
Total Hits: 17 | Today: 0
|
Author: AzamSharp
|
Rating:
|
|
ADO.NET 2.0 introduces a new model for executing queries. In ADO.NET 1.X we had to wait for the first query to finish the work before executing the new query. Well, fortunately that wait is now over since ADO.NET 2.0 introduces the asynchronous query execution model which allows the developer to execute multiple queries asynchronously; hence not waiting. In this article I will demonstrate how to execute queries using asynchronous model available in ADO.NET 2.0 framework....
|
|
|
|
Total Hits: 25 | Today: 0
|
Author: Julia Lerman
|
Rating:
|
|
The Microsoft® .NET Framework 2.0 delivers an updated ADO.NET that will streamline your data access development efforts. The ADO.NET team has worked with both the System.Xml team and the SQL Server™ team to provide a consistently rich developer experience, crossing technology boundaries from ADO.NET to XML and back. This will all be apparent as you dig into ADO.NET 2.0. There are improvements on so many fronts that you will certainly be pleased....
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: John Papa
|
Rating:
|
|
Enterprise development has been moving towards a discon-nected model in recent years and ADO.NET development is no exception. While the disconnected model of the ADO.NET DataSet offers great flexibility, that adaptability also means looser control over data updates than you get with a connected data access model. One related issue is data concurrency. This month I'll focus on concurrency violations that occur when multiple rows could be saved to the database in a single batch....
|
|
|
|
Total Hits: 35 | Today: 0
|
Author: AzamSharp
|
Rating:
|
|
ADO.NET 2.0 introduces a new model for executing queries. In ADO.NET 1.X we had to wait for the first query to finish the work before executing the new query. Well, fortunately that wait is now over since ADO.NET 2.0 introduces the asynchronous query execution model which allows the developer to execute multiple queries asynchronously; hence not waiting. In this article I will demonstrate how to execute queries using asynchronous model available in ADO.NET 2.0 framework....
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: Paul Wilson
|
Rating:
|
|
ADO.NET v2.0 will finally provide a built-in object-relational mapper called ObjectSpaces. What is an O/R mapper? Its a framework that lets you totally avoid SQL and stored procs! Note that I'm not talking about generating the SQL or stored procs, like many tools do now; no, I mean totally avoid it and have the framework transparently do all the CRUD for you. That may sound like an impossible dream, if you've never looked into these types of tools, but its very doable and its been rather commonp...
|
|
|
|
Total Hits: 71 | Today: 0
|
Author: Jorg Wegener
|
Rating:
|
|
A relational database offers more or less a static structure to store data. Often several tables and relations are needed to reach a minimum of flexibility. Nevertheless a relational database is still often the first choice for storing data. In some cases it may be better to store the data in a directory service like Active Directory Application Mode (ADAM), which can also provide user authentication for an application. In this article Jörg Wegener describes how to implement ADAM within a web ap...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|
Back in ADO, Remote Data Service (RDS) allowed a developer to write a query to join tables, make changes to the data which was returned, and then send the changes back to the database with a simple call. In other words, it figured out which columns came from which table and made the changes to the right table. Does ADO.NET only support "smart" updates for queries of single tables, not queries involving joins? Yes, that's the case. DataAdapter can send changes from a DataSet/DataTable to a back-e...
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: John Papa
|
Rating:
|
|
ADO.NET 2.0 sports some exciting enhancements to the core classes found in ADO.NET 1.x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency. There have even been some major changes throughout the lifecycle of the pre-beta and beta versions of ADO.NET 2.0, such as the improvements to the new batch updating process. With the final release of ADO.NET 2.0 fast approaching and the feature set becoming more stable, it's time to take a closer...
|
|
|
|
Total Hits: 9 | Today: 0
|
Author: John Papa
|
Rating:
|
|
ADO.NET 2.0 sports some exciting enhancements to the core classes found in ADO.NET 1.x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency. There have even been some major changes throughout the lifecycle of the pre-beta and beta versions of ADO.NET 2.0, such as the improvements to the new batch updating process. With the final release of ADO.NET 2.0 fast approaching and the feature set becoming more stable, it's time to take a closer...
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Ali Hamdar
|
Rating:
|
|
Microsoft Indexing Service and OLE DB when put together are really something. The Microsoft Indexing Service provides property filtering and searching as well as full-text indexing and searching of file data. Indexing Service provides filters for several popular file formats including Microsoft Word, Microsoft PowerPoint, Microsoft Excel, and HTML. Filters are also available for plain-text. Filters can be written by customers and third-party vendors for other formats as well. One purpose of a fi...
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: John Papa
|
Rating:
|
|
ADO.NET 2.0 sports some exciting enhancements to the core classes found in ADO.NET 1.x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency. There have even been some major changes throughout the lifecycle of the pre-beta and beta versions of ADO.NET 2.0, such as the improvements to the new batch updating process. With the final release of ADO.NET 2.0 fast approaching and the feature set becoming more stable, it's time to take a closer...
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: A. Bromberg, Ph.D.
|
Rating:
|
|
I've done some fun work with Compressed DataSets using BinaryFormatter and a DataSetSurrogate class to "flatten out" the ADO.NET DataSet so it can be efficiently serialized in Binary format, as well as some experiments with Angelo Scotto's CompactFormatter, which is a bit faster and offers more compact results than BinaryFormatter. This, combined with ICSharpCode SharpZipLib compression, can make for a very small remotable byte stream that can be sent over the wire via Remoting, sockets, or a We...
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: Satheesh Babu
|
Rating:
|
|
In ADO.NET, when performing bulk database operations, the thread that is executing it will wait for the database operation to complete and proceed the execution of other lines. If the database operation is bulk and complicated, the amount of time the thread waiting will be more. To answer this, ADO.NET 2.0 is packed with a new feature to execute bulk operations asynchronously. This article takes you through the implementation of this new feature....
|
|
|
|
Total Hits: 41 | Today: 0
|
Author: Moderator1
|
Rating:
|
|
This article explores the concept of using DataTableReader in the place of SqlDataReader and DataTable, also explains the methods of creating, reading and using the DataTableReader in the web applications.
In this fast and furious world, everyone needs everything to be faster. Once upon a time Pentium MMX was considered as faster system, but now we don’t accept even Pentium Dual core as the fastest system. If this is the situation for a computer system, then what will be the situation for the...
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Bob Beauchemin
|
Rating:
|
|
ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific....
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Pablo Castro
|
Rating:
|
|
Get an overview of the new asynchronous execution functionality in ADO.NET 2.0, the scenarios it was developed to enable, plus some of the issues to keep in mind when using this feature....
|
|
|
|
Total Hits: 19 | Today: 0
|
Author: Jackie Goldstein
|
Rating:
|
|
Learn about the new ADO.NET 2.0 features in the DataSet .NET Framework class and the classes that are closely related to it. These changes include both functional and performance enhancements to the DataSet, DataTable, and DataView classes....
|
|
|
|
|
|
