Top 10 New Features of ADO.NET 2.0
Loading
صفحه 1 از 2 12 آخرینآخرین
نمایش نتایج: از 1 به 10 از 16

موضوع: Top 10 New Features of ADO.NET 2.0

  1. #1
    مدير انجمن Array M.taghavi آواتار ها
    تاریخ عضویت
    Thursday 1 January 1970
    نوشته ها
    610
    Thanks
    0
    Thanked 1 Time in 1 Post

    Post Top 10 New Features of ADO.NET 2.0





    This article summarizes the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0. In my following articles I will discuss these features in more details with sample examples.
    Here is a list of new and updated additions to ADO.NET:

    1. Bulk Copy Operation

    Bulk copying of data from a data source to another data source is a new feature added to ADO.NET 2.0. Bulk copy classes provides the fastest way to transfer set of data from once source to the other. Each ADO.NET data provider provides bulk copy classes. For example, in SQL .NET data provider, the bulk copy operation is handled by SqlBulkCopy class, which can read a DataSet, DataTable, DataReader, or XML objects.

    2. Batch Update

    Batch update can provide a huge improvement in the performance by making just one round trip to the server for multiple batch updates, instead of several trips if the database server supports the batch update feature. The UpdateBatchSize property provides the number of rows to be updated in a batch. This value can be set up to the limit of decimal.

    3. Data Paging

    Now command object has a new execute method called ExecutePageReader. This method takes three parameters - CommandBehavior, startIndex, and pageSize. So if you want to get rows from 101 - 200, you can simply call this method with start index as 101 and page size as 100.

    4. Connection Details

    Now you can get more details about a connection by setting Connection's StatisticsEnabled property to True. The Connection object provides two new methods - RetrieveStatistics and ResetStatistics. The RetrieveStatistics method returns a HashTable object filled with the information about the connection such as data transferred, user details, curser details, buffer information and transactions.

    5. DataSet.RemoringFormat Property

    When DataSet.RemotingFormat is set to binary, the DataSet is serialized in binary format instead of XML tagged format, which improves the performance of serialization and deserialization operations significantly.

    6. DataTable's Load and Save Methods

    In previous version of ADO.NET, only DataSet had Load and Save methods. The Load method can load data from objects such as XML into a DataSet object and Save method saves the data to a persistent media. Now DataTable also supports these two methods.

    You can also load a DataReader object into a DataTable by using the Load method.

    7. New Data Controls

    In Toolbox, you will see these new controls - DataGridView, DataConnector, and DataNavigator. See Figure 1. Now using these controls, you can provide navigation (paging) support to the data in data bound controls.



    Figure 1. Data bound controls.

    8. DbProvidersFactories Class

    This class provides a list of available data providers on a machine. You can use this class and its members to find out the best suited data provider for your database when writing a database independent applications.

    9. Customized Data Provider

    By providing the factory classes now ADO.NET extends its support to custom data provider. Now you don't have to write a data provider dependent code. You use the base classes of data provider and let the connection string does the trick for you.

    10. DataReader's New Execute Methods

    Now command object supports more execute methods. Besides old ExecuteNonQuery, ExecuteReader, ExecuteScaler, and ExecuteXmlReader, the new execute methods are ExecutePageReader, ExecuteResultSet, and ExecuteRow. Figure 2 shows all of the execute methods supported by the command object in ADO.NET 2.0.



    Figure 2. Command's Execute methods.

    Summary

    ADO.NET 2.0 provides many new and improved features for developers to improve the performance and reduce the code. In this article, I discussed top 10 features of ADO.NET 2.0. In my forthcoming articles, I will be discussing these features in more details.




پاسخ با نقل قول پاسخ با نقل قول

  • #2
    كاربر عادي Array
    تاریخ عضویت
    Sunday 25 December 2005
    نوشته ها
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    با سلام

    ضمن تشکر بابت مطلب بالا .
    آیا Ebook آموزشی ADO.NET 2.0 دارید . ؟
    اگر سایتی را میشناسید که مثال هم داشته باشد بسیار عالی ست .

    با تشکر .

  • #3
    كاربر عادي Array
    تاریخ عضویت
    Tuesday 31 January 2006
    نوشته ها
    172
    Thanks
    0
    Thanked 1 Time in 1 Post

    Question

    Ebook:A First Look at ADO.NET and System.Xml v. 2.0

  • #4
    كاربر عادي Array
    تاریخ عضویت
    Tuesday 31 January 2006
    نوشته ها
    172
    Thanks
    0
    Thanked 1 Time in 1 Post

    پیش فرض Ebook :Professional ADO.Net 2.0

    آقاي عابدجو
    اينهم كتابي جديد در باره ADO.Net 2

    http://www.developercenter.ir/Forum/...ead.php?t=1447

  • #5
    كاربر عادي Array
    تاریخ عضویت
    Friday 14 April 2006
    نوشته ها
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    سلام دوستان من یک مشکل دارم زمانی که می خوام جستجو کنم اگه کاراکتر "ی" در اون کلمه باشه جستجو نمیکنه چرا
    نفس که از گرم گاه سینه می اید بورن ابری شود تاریک همچو دیوار ایستد در پیش چشمانت نفس که این است پس دیگر چه داری چشم زه چشم دوستان دور یا نزدیک

  • #6
    كاربر عادي Array leo_messi19 آواتار ها
    تاریخ عضویت
    Friday 17 August 2007
    محل سکونت
    @Home
    نوشته ها
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    قبل از جستجو متنت یه n بذار
    ('مهدی'family like(N

  • #7
    كاربر عادي Array
    تاریخ عضویت
    Friday 11 January 2008
    نوشته ها
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    سلام به همگی اعضا
    اگه کتاب خوب و جامعی در باره ado.net میخواین من دارم
    کتاب خیلی با حالی

  • #8
    كاربر عادي Array
    تاریخ عضویت
    Wednesday 3 January 2007
    نوشته ها
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    خوب اگه ميشه اين لطف رو بكن!!!!!!!!!

  • #9
    كاربر عادي Array
    تاریخ عضویت
    Sunday 12 August 2007
    نوشته ها
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    من هم به خاطر e-book، تشکر می کنم

  • #10
    كاربر عادي Array
    تاریخ عضویت
    Monday 20 November 2006
    نوشته ها
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    پیش فرض

    سلام به همه دوستان
    کسی اطلاعی در مورد دخیره و بازیابی فایل های ورد تو sql نداره
    ممنون می شم اگه راهنمایی کنید

  • صفحه 1 از 2 12 آخرینآخرین

    علاقه مندي ها (Bookmarks)

    علاقه مندي ها (Bookmarks)

    مجوز های ارسال و ویرایش

    • شما نمیتوانید موضوع جدیدی ارسال کنید
    • شما امکان ارسال پاسخ را ندارید
    • شما نمیتوانید فایل پیوست کنید.
    • شما نمیتوانید پست های خود را ویرایش کنید
    •