Enterprise library advantages over own custom data connection classes RRS feed

  • Question

  • User-1064469800 posted

    Hello, can any one help me with the exact advantages of enterprise library manager (Data Application Block). Is it possible to switch the database easily using data application block (eg. from sql server to Oracle) with out changing any code

    Please help

    Thursday, May 2, 2013 10:38 PM

All replies

  • User-837620913 posted

    Yes you can switch to a different database - as long as you create a database instance using the Factory Pattern in the application block and not hard-coding them, and not writing any SQL that is PL-SQL specific (e.g., using cursors or custom PL-SQL extensions).

    See this article for examples:  http://msdn.microsoft.com/en-us/magazine/cc163766.aspx

    Also check out this article on the Data Access App Block using the Oracle .NET Provider:  http://www.codeproject.com/Articles/19581/Microsoft-Enterprise-Library-Data-Access-Block-DAA

    Friday, May 3, 2013 5:52 AM
  • User-1064469800 posted

    Hi, thanks for the information. Incase if we stick to only sql server and we know in future also will not change to any other database system then what are the additional benefits will get from Enterprise data access application block over sqlhelper which is light weight data application support class

    Friday, May 3, 2013 1:45 PM