Home > Oracle Database / Applications News > Oracle updates Microsoft developer tools
Oracle Database / Applications News:
EMAIL THIS

Oracle updates Microsoft developer tools

By Mark Brunelli, News Editor
14 Jun 2007 | SearchOracle.com

Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Oracle has released some free tools for Microsoft .NET and ASP.NET developers who build applications that run on Oracle Database 10g.

Oracle executives said the newly unveiled beta versions of Oracle Data Provider for .NET and Oracle Developer Tools for Visual Studio .NET were created to help increase the productivity of Microsoft developers running Oracle and generally to make it easier for developers to use the two technology giants' technologies in conjunction with one another.

Oracle says both of the newly updated versions incorporate new capabilities for supporting ASP.NET, Microsoft's framework for building Web applications and Web sites. The releases also enable developers to build .NET applications using complex data types by allowing the creation of .NET custom types from Oracle abstract data types, according to the company. Some of those new capabilities include User Defined Type support, Source Control integration and enhanced integration with Visual Studio 2005.

More info for Oracle and .NET developers:

Oracle unveils new tools for .NET developers

Ten things Oracle developers should never do

Along with the new Oracle Data Provider for .NET release, Oracle is introducing Oracle Providers for ASP.NET, a set of tools that integrate with ASP.NET Services to enable ASP.NET applications users to manage state and other information within an Oracle database.

The beta version of Oracle Developer Tools for Visual Studio .NET offers new ASP.NET Web development support, which lets developers automatically generate code by dragging and dropping database objects onto their ASP.NET Web pages. It also features integrated source control capabilities, easing the back up and versioning of .NET applications running with Oracle Database, by allowing Oracle scripts to be source-controlled within Visual Studio. The system supports any widely used source control systems and works with Microsoft Visual Studio 2005 or Visual Studio .NET 2003, according to Oracle. The tool also includes enhanced script editing and execution allowing for easier testing and deployment, company executives said.

"As far as visual studio integration goes, we're focusing on ASP.NET Web developers," said Christian Shay, an Oracle principal product manager. "So in this release, Web developers on the Microsoft platform can write Web applications that go against Oracle with very little coding required. They'll be able to basically drag and drop their way to a running application."

Some other key new features in Oracle Developer Tools for Visual Studio .NET include enhanced support for Microsoft Server Explorer, which is Microsoft's tree control system.

"From that tree control you can actually navigate through your Oracle database schema and look at all the objects, tables, packages and PL/SQL packages, and we have designers and wizards which are completely user-interface-based which will let users design their tables and views and packages in a user interface," Shay said. "On top of that we are also enhancing our .NET code generation for Windows applications [by] supporting the Visual Studio 2005 Data Sources window, which is how you begin the process of generating code. We're [also] supporting the Data Set Designer and the Table Adapter Configuration Wizard. By supporting all of that, now developers who have experience with any type of database development -- even if it's not Oracle -- can take that experience and apply it directly to Oracle."

Oracle says Data Provider for .NET helps developers more easily access information from the Oracle Database. The product lets developers exploit many of Oracle Database's capabilities, including application security context, clustering and native Oracle data types such as LOBs and REF cursors.

"[Oracle Data Provider for .NET] is just a way to get data from the Oracle database into your .NET application server so that you can get access to Oracle's advanced features like [Real Application Clusters], Advanced Security, XML data types and the performance tuning abilities of the Oracle database," said Alex Keh, another Oracle principal product manager.

The Oracle Developer Tools for Visual Studio .NET beta and the Oracle Data Provider for .NET beta are both available for download at no cost from the Oracle Technology Network.



Tags: Oracle XMLOracle stored proceduresOracle and SQLUsing Oracle PL/SQLOracle Java and J2EEOracle DBA toolsVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
Oracle XML
Oracle XML DB generates power for electrical agency
Oracle's content management software plan takes shape
Top five data management buzzwords
Oracle updates free Web development tool
Oracle open sources TopLink at EclipseCon
Oracle or SQL Server for developing social networking site?
What is SOA?
Calling Web service from Oracle vs. .Net
Introduction to BPEL
Using PL/SQL to access a Web service

Oracle stored procedures
Stored procedure to autotransfer data between Oracle servers
Insufficient privileges error when creating stored procedure
ORA-01422 error when procedure returns more than one row
Calling procedure inside another procedure in anonymous block
Can I make a second connection to Oracle without losing the first?
How to create an index using a procedure in Oracle
Procedure compiles but does not execute
Tool in Oracle 10g to keep track of execution of queries
ORA-04082: NEW or OLD references not allowed in table level triggers
Execute SQL statement from table in other schema

Oracle and SQL
Using the SQL GROUP BY clause for counting combinations
How to use an SQL CASE expression
How to use the Oracle Database SQL Reference Manual
How to use SQL Developer to run SQL statements
How to work with the Oracle database home page
How to use SQL*Plus in Oracle
How to use SQL Developer to work with an Oracle database
How to view and edit table column definitions
How to sort an SQL UNION query with special ORDER BY sequence
How to use string functions to make an SQL join
Oracle and SQL Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
DSML  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Oracle News, Oracle Training, Oracle Management
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts