Christian Shay

Subscribe to Christian Shay feed
Christian Shayhttp://www.blogger.com/profile/01109392506865828110noreply@blogger.comBlogger35125
Updated: 10 hours 37 min ago

Windows and .NET sessions at Openworld

Thu, 2017-09-28 09:25
Interested in Oracle Database on Windows performance and security, Active Directory, or .NET development topics? At Oracle Openworld SF next week there's a host of Windows and .NET sessions, hands on labs, and demogrounds for you to check out.

Here's the list of Windows sessions and demogrounds with times.
And here's the list of .NET development sessions, hands on lab, and demogrounds with times.

Use schedule builder to reserve your seats in any of those sessions before they fill up.

You can also visit us at our booth at the Moscone West "Exchange" (formerly known as "Demogrounds"). We'll have .NET experts as well as Oracle Database on Windows experts standing by to answer your questions or to give you a demo.

You can find us using this handy dandy map (we are on the left side of the exhibition hall with other Oracle application development booths) - click the image to enlarge:

See you at the show!!!


Setting up Transport Layer Security/Secure Sockets Layer for Managed ODP.NET

Mon, 2017-01-09 08:53

[I was chatting with ODP.NET product manager, Alex Keh, and he let me know about some known issues that developers currently face when using managed ODP.NET with Transport Layer Security/Secure Sockets Layer (TLS/SSL) wallets. I asked him for more details and he wrote up the step by step walkthrough you see below. If you have questions about the steps provided below, please post to the ODP.NET OTN forum for assistance. -CS]


Setting up managed ODP.NET Transport Layer Security/Secure Sockets Layer (TLS/SSL) wallets correctly can be tricky for those that don't do it on a regular basis. Microsoft Windows now restricts wallets from using the MD5 algorithm. Oracle wallets may have been generated with this algorithm as that was the default option in Oracle Public Key Infrastructure (orapki) utility 12.1 and earlier.

When you setup TLS/SSL and encounter an "ORA-0052: Failure during SSL handshake" error combined with a 0x80004005 error code and first inner exception "A SSPI-call failed" and second inner exception "A token sent to the function is invalid", then it is very likely that Microsoft Security Support Provider Interface (SSPI) rejected your Oracle Wallet, such as when MD5 is used. This is a failure on the handshake. You can resolve this error by using the SHA-2 algorithm instead. We'll describe how shortly.

If the second inner exception instead indicates "The credentials supplied to the package were not recognized", it is possible the user certificate was generated without a certificate authority (CA). You can resolve this error by using orapki to generate a CA/root certificate and then regenerating your user wallet/certificate to point to this new CA/root certificate. More info on how to do this is below.

Orapki refers to orapki.exe. This utility is part of full Oracle client (admininstrator) installations. It is not included with Oracle Instant Client. The utility is only needed to setup up the wallet; it is not necessary to deploy it with the wallet.

The steps below will regenerate your Oracle Wallet using orapki. Any orapki version can be used to generate the wallet with these instructions.


1. Create root wallet, for example, a CA wallet.

orapki wallet create -wallet ./root -pwd yourpassword

2. Add a self-signed certificate (CA certificate) to the root wallet.

orapki wallet add -wallet ./root -dn 'CN=yourroot' -keysize 1024 -self_signed -validity 3650 -pwd yourpassword -sign_alg sha512

3. Export the self-signed certificate from the wallet.

orapki wallet export -wallet ./root -dn 'CN=yourroot' -cert ./root/b64certificate.txt -pwd yourpassword

4. Create a user wallet, for example, a customer wallet.

orapki wallet create -wallet ./user -pwd yourpassword -auto_login

5. Add a certificate request.

orapki wallet add -wallet ./user -dn 'CN=clientshostname' -keysize 1024 -pwd yourpassword -sign_alg sha512

6. Export the certificate request.

orapki wallet export -wallet ./user -dn 'CN=clientshostname' -request ./user/creq.txt -pwd yourpassword

7. Create a certificate issued by a CA.

orapki cert create -wallet ./root -request ./user/creq.txt -cert ./user/cert.txt -validity 3650 -pwd yourpassword -sign_alg sha512

8. Add a trusted certificate (CA certificate) to the wallet. This example assumes the same CA for both the client and server wallets.

orapki wallet add -wallet ./user -trusted_cert -cert ./root/b64certificate.txt -pwd yourpassword

9. Add a user certificate.

orapki wallet add -wallet ./user -user_cert -cert ./user/cert.txt -pwd yourpassword -sign_alg sha512

10. Display contents of user wallet.

orapki wallet display -wallet ./user -pwd yourpassword

11. Create a server wallet.

orapki wallet create -wallet ./server -pwd yourpassword -auto_login

12. Add a server certificate request.

orapki wallet add -wallet ./server -dn 'CN=servershostname' -keysize 1024 -pwd yourpassword -sign_alg sha512

13. Export the certificate request.

orapki wallet export -wallet ./server -dn 'CN=servershostname' -request ./server/creq.txt -pwd yourpassword

14. Create a server certificate issued by a CA.

orapki cert create -wallet ./root -request ./server/creq.txt -cert ./server/cert.txt -validity 3650 -pwd yourpassword -sign_alg sha512

15. Add a trusted certificate (CA certificate) to the server wallet. This example assumes the same CA for both the client and server wallets.

orapki wallet add -wallet ./server -trusted_cert -cert ./root/b64certificate.txt -pwd yourpassword

16. Add a user_cert certificate for the server wallet.

orapki wallet add -wallet ./server -user_cert -cert ./server/cert.txt -pwd yourpassword -sign_alg sha512

17. Display contents of server wallet.

orapki wallet display -wallet ./server -pwd yourpassword


Oracle Openworld SF: Windows and .NET Sessions and demogrounds

Fri, 2016-09-16 12:00

I'll be at Oracle Openworld San Francisco (Sept 18-22) next week and we have a host of sessions aimed for .NET developers and Oracle Database on Windows administrators. Click the links below for the session times and locations.

Oracle Database on Windows Sessions
 Active Directory and Windows Security Integration with Oracle Database [CON6573]
Best Practices for Oracle Database Performance on Windows [CON6575]
What's New with Oracle Database 12c on Windows: On-Premises and in the Cloud [CON6576]

.NET Development Sessions

Best Practices for Performance Part 1: .NET and Oracle Database [CON6574]
Best Practices for Performance Part 2: .NET and Oracle Database [CON6610]
PL/SQL Programming for .NET Developers: Tips, Tricks, and Debugging [CON6612]
What’s New for .NET Developers in Oracle Database [CON6577]
Best Practices for High Availability: .NET and Oracle Database [CON6580]
Meet the Oracle Programming and Scripting Experts [MTE7200]


I've also uploaded a map showing where the demobooth is located (SDB-003 in Moscone South).
Click here to view the image in full res.



Oracle Announces Plans for Visual Studio 2015 Support

Tue, 2015-07-07 08:36

Oracle plans to offer a new version of the Oracle Developer Tools for Visual Studio integrated with Microsoft Visual Studio 2015. This new version is planned to be available within one month of Visual Studio 2015's Release to Manufacturing (RTM) date. As with earlier releases of Visual Studio, Oracle has partnered closely with Microsoft as part of the Visual Studio Industry Partner Program to make this release possible. Keep an eye on the OTN .NET Developer Center or follow us on Twitter for the upcoming release announcements.

Oracle Presentations at Chicago and Milwaukee Area .NET User Groups

Mon, 2015-04-27 08:32

Attention Chicago and Milwaukee area .NET developers: Please join me next month as I visit the Lake County .NET Users' Group and the Wisconsin .NET Users Group to speak to members on the topic "Oracle .NET and Visual Studio: Intro and Best Practices". Details below. Please be sure to sign up at the user group websites so they know you are coming and to find out about any last minute changes in time/location. Free food and drink will be provided.

Tuesday May 12th, 7:00pm:
Wisconsin .NET Users Group

Meeting location:
Thomson Reuters 
(Town Hall)
450 North Sunny Slope Road 
Brookfield, WI 53005  

Thursday May 14th, 6:45 pm:
Lake County .NET Users' Group

Meeting location:
College of Lake County
Technology Building, room T326-328
19351 West Washington Street
Grayslake, IL 60030-1198

Oracle .NET and Visual Studio: Intro and Best Practices

The first part of this session introduces Oracle Database support for .NET, including Oracle Data Provider for .NET (ODP.NET) and Oracle Developer Tools for Visual Studio. Step by step demos will show how to get started using these free products. We will also discuss the latest features including fully-managed ODP.NET, schema comparison tools, Oracle Database 12c multitenant container database support, NuGet packaging, and new features for Entity Framework.

The second part of the session explores coding best practices for achieving faster .NET Oracle database access performance. We examine techniques for optimizing connection pooling, caching, data fetching and updating, statement batching, and Oracle data type usage. We show how to use Oracle tuning tools to tune adhoc SQL as well as tuning a running database application to get the best possible performance. 

See you there!

Free Webinar: Getting Started with Oracle and .NET

Mon, 2015-03-16 07:48

Please join me on Wednesday, March 18th at 12 noon Eastern time for a one hour webinar going over the basics on how to get started developing C#/VB.NET apps for Oracle Database.

No signup needed. The Webex information is located here:

http://www.oracle.com/technetwork/database/application-development/appdev-webseries-2430444.html

How do you get started using Visual Studio to develop .NET web applications that leverage the power of Oracle Database 12c? This beginner-level webcast answers that question and introduces Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET (ODP.NET), Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by step-demos show you how to get started using each of these free products.

See you on Wednesday!

(To subscribe to this blog, please click here)

Oracle Data Provider for .NET now on NuGet

Mon, 2015-03-02 08:30

ODP.NET, Managed Driver is now on NuGet, meaning that you can add ODP.NET to your Visual Studio project with just a few clicks in the NuGet Package Manager. We've also published an Oracle By Example walkthrough to take you step by step through the process of using NuGet and ODP.NET.

Here we are in the NuGet Package Manager:




When searching for us in the package manager, make sure to get the official package - look for the word "Official" in the title.



There's actually two NuGet packages available:

ODP.NET, Managed Driver - Official
NuGet id: Oracle.ManagedDataAccess

This adds Oracle.ManagedDataAccess.dll to your project and also makes needed configuration entries in your app.config or web.config.


ODP.NET, Managed Entity Framework Driver - Official
NuGet id: Oracle.ManagedDataAccess.EntityFramework

This adds Oracle.ManagedDataAccess.EntityFramework.dll as well as config file configuration. It also has a dependency on the ODP.NET package above and will pull it into your project  as well as EF 6 if needed.

If you want to host this package on your local intranet, it is also available for download on the OTN .NET download page.

Please note that if you want to use Visual Studio integration features, such as browsing your Oracle Schema in Server Explorer, or using Entity Designer or Table Adapter Configuration wizard, you should still install Oracle Developer Tools for Visual Studio, as a NuGet package  does not provide any of the Visual Studio integration components needed to do design time work.

ODAC 12c Release 3 Beta now available

Fri, 2014-09-26 11:17

The Oracle Data Access Components (ODAC) 12c Release 3 Beta is now available! This beta introduces numerous new features for Entity Framework and managed ODP.NET.


Entity Framework 6 Code FirstODAC 12c R3 is the first ODP.NET release to certify with Entity Framework (EF) 6 and EF Code First. EF Code First is a popular development model for .NET object-relational mapping. Developers define the application domain model using source code, rather than with a designer or an XML-based configuration file. An EF Code First model's classes are defined in code through Plain Old CLR Objects (POCOs).

This support includes interoperability with the two Entity Framework methods that control the resulting Oracle data type: Data Annotations and Code First Fluent API. Data Annotations permit you to explicitly mark a class property with one or more attributes, whereas the Code First Fluent API permits you to use code rather than attributes to achieve the same goal.

Code First developers can modify and create their database schema as their model changes via EF Code First Migrations. ODP.NET supports EF Code First Migrations through the Visual Studio Package Manager Console commands.

These features are all available in both managed and unmanaged ODP.NET.


New ODP.NET, Managed Driver FeaturesSeveral new managed ODP.NET features have been delivered with this beta. XML DB developers can now use all of ODP.NET's XML classes that are supported by ODP.NET, Unmanaged Driver with the exception of the OracleXmlType.IsFragment and OracleCommand.XmlCommandType properties. This makes Unmanaged ODP.NET XML DB application migration to the managed driver a simple process.

ODP.NET, Managed Driver supports the VARCHAR2, NVARCHAR2, and RAW data types up to 32 KB in size. No code changes are required to use the larger data types, (which are a new Oracle Database 12c feature). By storing more data, developers can use these data types more frequently, providing programming flexibility. In addition, SQL Server to Oracle Database application migration is easier with these new data type sizes.

When using array binding to execute multiple DML statements, ODP.NET, Managed Driver can now provide an array that lists the number of rows affected for each input value from the bound array, rather than just the total number of rows affected. To retrieve the row count, ODP.NET can call the OracleCommand.ArrayBindRowsAffected property. You can use this information to better evaluate the DML's efficiency and whether the data changes were correctly applied.


.NET Framework 4.5.2 and Distributed TransactionsThe ODP.NET managed and unmanaged beta drivers are certified with new .NET Framework 4.5.2 release. .NET 4.5.2 introduces a new Microsoft Distributed Transaction Coordinator feature that allows ODP.NET, Managed Driver to support distributed transactions without requiring you to deploy Oracle.ManagedDataAccessDTC.dll with your application.


More to ComeUp next, the ODAC team plans a NuGet installable managed and unmanaged ODP.NET. Stay tuned to @OracleDOTNET to learn when it is available. We hope to hear your feedback via the OTN discussion forums.

Oracle Openworld SF .NET and Windows Sessions

Fri, 2014-09-26 11:04
Oracle Openworld San Francisco begins this Sunday, September 28!  Join the Oracle .NET development team and your fellow .NET developers and learn about new Oracle .NET features, including Entity Framework, Code First, Code First Migrations, NuGet packaging, support for new Oracle Database 12c features and much more. Meet Oracle and .NET experts at the .NET Demogrounds booth and at the "Ask the Experts" Q+A session. The .NET schedule listing is at this link. Register at the OpenWorld website. See you there!

Microsoft Deprecates OracleClient: Time to Consider Moving to ODP.NET

Mon, 2009-07-06 22:52
Microsoft recently announced that it will deprecate Microsoft System.Data.OracleClient. For existing Microsoft OracleClient developers, especially those that haven't taken a look at the Oracle Data Provider for .NET (ODP.NET) in some time, this is a good time to look at ODP.NET again for new development or to migrate existing Oracle .NET applications. In recent years, ODP.NET has added lots of new features -- such as performance tuning, user-defined types, advanced queuing, RAC connection pooling, and supporting multiple ODP.NET client versions simultaneously on the same machine.

Alex Keh, who is the product manager for ODP.NET, has put together a special new webhome for developers using OracleClient...its called ODP.NET for Microsoft OracleClient Developers. This web page provides good information about why developers choose to migrate from ODP.NET from Microsoft OracleClient. Alex told me that the page will also provide a step-by-step Microsoft OracleClient to ODP.NET migration tutorial in the near future, which should be extremely useful. If you have questions about what this deprecation means for your company, please contact Alex over at alex.keh [at] oracle [dot] com or post to the ODP.NET Forum (OTN registration required).

In reading various comments on the MSDN post and elsewhere, I noticed a few misconceptions about ODP.NET that I would like to clarify:

Misconception: "This deprecation means I have to pay for an Oracle provider now!"
Fact: ODP.NET is free! You don't need to pay for a third party provider if you don't want to

Misconception: "I have to download a particular version of ODP.NET depending on the version of my database."
Fact: Any version of ODP.NET works with any version of Oracle Database. So you can use the latest version (currently 11.1.0.7) and use it against a 9.2, 10, or 11g database!

Misconception: "I'll have to use the Oracle installer when I deploy my app. Argh!!!"
Fact: At deployment time, you don't have to use the Oracle installer to install ODP.NET if you don't want to. If you so choose you can write your own installer, using scripting or Installshield or whatever you want. All you need to do is download the XCOPY version of ODP.NET. As a bonus, it has a smaller footprint too!

Misconception: "If I need to standardize on/test different apps with different versions of ODP.NET I'm in big trouble!"
Fact:Multiple versions of ODP.NET can live on the same box and your application can target whatever specific one it was tested with. Not everyone has multiple apps that have been tested with different versions of ODP.NET but it happens.

Misconception: "I hit a bug in ODP.NET 9/ODP.NET 10! I can't use ODP.NET because of it!"
Fact: If you hit some nasty bug of some sort with ODP.NET 9 or even 10, make sure to download the 11.1 version and try it as the bug is likely fixed in the years that passed. Again, it does not matter what version of the database you are using, the 11g ODP.NET version will work against them all and over the years we have added tons of new features and bug fixes.

So again, please check out the ODP.NET for Microsoft OracleClient Developers webpage. I'll blog again when the migration step-by-step guide is posted there, so feel free to subscribe to my blog to get an alert when that happens!

Happy coding :)

.NET and Windows OpenWorld Sessions Filling Up Fast!

Tue, 2008-09-16 10:23

Summary: Seats are filling up fast for Oracle OpenWorld .NET and Windows sessions, so use Schedule Builder and reserve a seat for yourself today!

Oracle OpenWorld will be taking over the city of San Francisco next week (September 21-25th). And once again we bring back the popular "Oracle Develop", a special 2 day intensive track of content created specifically for the Oracle developer - including a .NET developer track.

This years Oracle Develop .NET track will provide comprehensive coverage of Oracle's .NET technologies including new Oracle Database 11g features, introductory material, and deep dive content. Oracle Develop is perfect for all levels of Oracle on .NET developers, from beginner to advanced. In addition to sessions we also have a .NET Hands on Lab, which lets you get your hands dirty and take Visual Studio 2008 for a joyride! Mark Williams, the author, .NET guru and OTN "Ace Director" who has probably answered one of your questions over at the ODP.NET Forum, will be on hand with me at the hands on lab to take your questions.

Once you register, I strongly urge you to use Schedule Builder to reserve seats in the sessions you are most interested in. I recommend doing so as many of our .NET and Windows sessions look like they are getting close to capacity.

If you can't make it to Oracle Develop content this year, please visit us in the Exhibition Hall (in the database area) for your own personalized demo of our latest features from an Oracle expert.
The .NET booth is booth L41 and Windows database booth is L19.

Oracle Develop .NET Sessions at a Glance

  • NET Data Caching: Client Result Cache and Database Change Notification to Maximize Performance
  • Building Microsoft Office Applications with Oracle Database and Visual Studio
  • PL/SQL Programming for .NET Developers: Tips, Tricks, and Debugging
  • Getting Started with Oracle and .NET
  • Database Development Lifecycle with Visual Studio: SQL, PL/SQL,.NET Stored Procedures, Source Control, and Deployment
  • Hands-on Lab: Building .NET Applications with Oracle
  • Optimizing .NET Data Access Performance with Oracle Database
  • New Oracle Features for .NET Developers
  • ASP.NET Web Development with Oracle

Windows Database Sessions

  • What's New for Windows and .NET in Oracle Database 11g
  • Active Directory and Windows Security Integration with Oracle Database
  • Best Practices for Oracle Database Performance on Windows
  • Best Practices for Oracle Database and Client Deployment on Windows

Join Oracle at Microsoft Tech·Ed in Orlando

Thu, 2008-06-05 06:15
Oracle is once again sponsoring Microsoft Tech·Ed (happening now through June 13 in Orlando, FL). We hope to see you there!

Microsoft has split the convention into two parts this year - a Developer week (happening right now), and an IT week (next week). Oracle will be present during both weeks, with a "Birds of a Feather" (BOF) session being hosted by Alex Keh (Oracle) tomorrow, and we'll have a large presence in the Expo hall next week during the IT part of the show. If you are in Orlando right now for Developer Week, I highly recommend you drop by the .NET BOF session as they have been very lively and informative and fun in past years! For those of you attending the IT show, please drop by our demo booth to get your questions answered and see your own personal demo of Oracle technologies. We'll also have a BOF session during IT week entitled "Managing a Mix of Oracle and Microsoft SQL Server Databases"

Here are the details:

Using Oracle with .NET - Birds of a Feather Session:
Hosted by Alex Keh, Oracle
When: This Friday, June 6 10:15 am
Where: Room S330E
Check online to verify room and time
What: Discuss tips and tricks on developing .NET applications with Oracle databases on topics, such as ASP.NET providers, best practices, and comparing available providers. Learn about the latest Oracle features for Microsoft Visual Studio 2008 and the Microsoft .NET Framework 3.5. Ask Oracle and .NET experts your most pressing questions.

Expo Hall

When: IT Week (June 10-13)
Where: Oracle booth (#1408)
What: Get custom demonstrations of the latest Oracle .NET, database clustering and tools, server management, and application server technology for Windows developers and administrators. Learn about Oracle Database 11g and its integration with new Microsoft technologies, such as Visual Studio 2008 and WIndows Server 2008. Enter to win an iPhone!

BOF: Managing a Mix of Oracle and Microsoft SQL Server Databases
When: Wednesday June 11? (check schedule for date, time, and location)

Hope to see you there!!!

Oracle Database 11g for Windows now available

Tue, 2007-10-23 12:36
Download Oracle Database 11g on Windows!

We'll be talking about Windows specific 11g new features at Oracle OpenWorld sessions so reserve your seat today!

Reserve your .NET and Windows OpenWorld Sessions Today!

Mon, 2007-10-22 11:45

Summary: Seats are filling up fast for Oracle OpenWorld .NET and Windows sessions, so use Schedule Builder and reserve a seat for yourself today!

Oracle OpenWorld will be once again taking over the city of San Francisco from November 11-15. It promises to be a truly amazing experience with over 1,600 sessions covering the full breadth of Oracle's offerings.

As you may recall, last year at OpenWorld we introduced "Oracle Develop", a special 2 day intensive track of content created specifically for the Oracle developer - including a .NET developer track. Well, it turned out to be so tremendously popular in San Francisco that we took the Oracle Develop show on the road to Korea, China, India, Germany, the Czech Republic, and the UK. Now we are back in San Francisco, having learned a lot about what you want in your sessions and we are offering even more of the good stuff that developers can use on their job!

This years Oracle Develop .NET track will provide comprehensive coverage of Oracle's .NET technologies including new Oracle Database 11g features, introductory material, and deep dive content. Oracle Develop is perfect for all levels of Oracle on .NET developers, from beginner to advanced. In addition to sessions we also have a .NET Hands on Lab, which lets you get your hands dirty and take Visual Studio for a joyride! You can attend Oracle Develop if you register for the full conference badge of course, but you could also sign up specifically for Oracle Develop.

Once you register, I strongly urge you to use Schedule Builder to reserve seats in the sessions you are most interested in. I recommend doing so as many of our .NET and Windows sessions look like they are getting close to capacity.

If you can't make it to Oracle Develop content this year, please visit us in the Exhibition Hall (in the database area) for your own personalized demo of our latest features from an Oracle expert.

Oracle Develop .NET Sessions at a Glance

  • Getting Started with Oracle and .NET
  • New Features in Oracle Database 11g for .NET Developers
  • Optimizing .NET Data Access Performance with Oracle Database
  • ASP.NET Web Development with Oracle Database
  • Database Development Lifecycle Management with Visual Studio: SQL, PL/SQL, and .NET Stored Procedure Development, Source Control, and Deployment
  • PL/SQL Programming for .NET Developers: Tips, Tricks, and Debugging
  • Using Complex Oracle Datatypes in .NET: LOBs, User-Defined Types, and XML
  • Building Scalable and Highly Available .NET Applications with Oracle RAC and Oracle Data Guard
  • .NET Data Caching: Using Oracle Change Notification and the Client Result Cache
  • Hands-on Lab: Building .NET Applications with Oracle

Windows Database Sessions
  • What's New for Oracle Database 11g on Windows and .NET
  • Oracle Database Integration with Active Directory and Windows Security
  • Best Practices for Performance of Oracle Database on Windows
  • Using Oracle RAC and Microsoft Windows 64-Bit as the Foundation for a Database Grid
  • Best Practices for Oracle Database and Client Deployment on Windows
  • Oracle Fusion Middleware: Best Practices and Interoperability for Windows, .NET, and Office Environments





See you there!

    New Oracle and .NET beta available now!

    Sun, 2007-06-03 23:06
    A major beta release is available now for ODP.NET as well as Oracle Developer Tools for Visual Studio .NET. This 11g beta release also marks the first release of a new product, Oracle Providers for ASP.NET. I've written a new white paper (with lots of screen shots) that illustrates the new Visual Studio enhancements. Keep an eye on this blog in the weeks ahead as I will be writing articles explaining how to take advantage of some of the new features such as ASP.NET code generation and User-Defined Type (UDT) support...

    We also have some new Oracle by Example walkthroughs that can help get you started:
    Oracle by Example: Building ASP.NET Web Applications with ODT
    Oracle by Example: Building .NET Applications Using ODT

    Here's a summary of the new features:

    Oracle Developer Tools for Visual Studio .NET New Features:

  • Visual Studio 2005 integration with Server Explorer, Data Sources Window, Dataset Designer, TableAdapter Configuration Wizard and more
  • Improved ASP.NET web developer support
  • Oracle Database script project to provide source control of Oracle scripts
  • SQL script editor
  • Built in support for executing SQL*Plus scripts
  • Explain plan support
  • Integration with Query Designer
  • New designer for granting/revoking privileges on schema objects
  • User-Defined Types: Create, explore, modify UDTs; custom class code generation for .NET applications
  • Data Window and Query Window enhancements


  • Oracle Data Provider for .NET:

  • Instant Client Support: Smaller ODP.NET client installation
  • User-Defined Types: Map Oracle objects and collections to .NET custom types and support REFs to object types
  • Process Database Down Events: ODP.NET automatically frees connections of a downed Data Guard instance
  • Windows-Authenticated User Connection Pooling: Windows-authenticated connections can now be pooled.
  • Connection Pool Performance Counters: Monitor connection pool status

  • Oracle Providers for ASP.NET:

  • Membership Provider: Stores and retrieves registered user information in the Oracle database
  • Role Provider: Stores and retrieves user role information in the Oracle database
  • Site Map Provider: Stores and retrieves site map information in the Oracle database
  • Session State Provider: Stores and retrieves session state information in the Oracle database
  • Profile Provider: Stores and retrieves user profile information in the Oracle database
  • Web Events Provider: Stores and retrieves ASP.NET health monitoring event information in the Oracle database
  • Web Parts Personalization Provider: Stores and retrieves personalization data in the Oracle database
  • Cache Dependency Provider: Automatically invalidates ASP.NET cached data based on changes made to the base data in the Oracle database
  • Oracle and .NET at Tech·Ed Orlando

    Tue, 2007-05-22 23:40
    Oracle will once again have a major presence at Tech·Ed this year (June 4-8).

    Be sure to stop by the Oracle booth on the demogrounds floor (aka "Partner Expo") for your own personalized demo of Oracle products. We will have demonstrations for Oracle and .NET, Grid Control, RAC, and App Server.

    At the .NET demo station you can get the first look at the upcoming release of the ODAC 11g beta including the following new features:

    ODT:
    Visual Studio 2005 integration with Server Explorer, Data Sources Window, Dataset Designer, TableAdapter Configuration Wizard and more
    Improved ASP.NET web developer support
    Oracle Database script project to provide source control of Oracle scripts
    Integration with Query builder and Query Designer
    User-Defined Types: Create, explore, modify UDTs and custom class code generation for .NET application
    and much more.....

    ODP.NET
    Instant Client Support: Smaller ODP.NET client installation
    User-Defined Types: Map Oracle objects and collections to .NET custom types and support REFs to object types
    and much more...

    ASP.NET Providers

    Sessions:

    We have a "Bird of a Feather" session, which is not a formal presentation, but more of a discussion with Oracle staffers and your fellow Oracle and .NET developers and DBAs. Come prepared with questions and bring your laptop if you feel like turning it into an installfest!

    BOF01: Using Oracle with .NET
    Monday, June 4, 2007 at 10:30 AM
    Room S331 A

    We are also co-presenting a "chalk talk" with Microsoft:

    DAT04-TLC - ADO.NET Entity Framework: Provider Model and Integration with Third-Party Databases
    Friday, June 8 1:00 PM - 2:15 PM, Blue Theater 12

    See you in Orlando!

    ODP.NET/ODAC for Vista now available

    Sun, 2007-05-06 23:04
    Coming right on the heels of Friday's release of Oracle Database for Windows Vista, we now have released ODAC 10.2.0.2.21 which is certified for Vista. You can download it here. This release is key because the Oracle Database on Vista downloads announced on Friday only include ODP.NET for .NET 1.x. If you need ODP.NET for .NET 2.x on Windows Vista, or any other of the ODAC products, you will need to download this. It includes all of the ODAC products, including ODP.NET and Oracle Developer Tools for Visual Studio .NET packaged up with a new version of the Oracle installer that is Vista friendly. Only the installer has been upgraded, not the individual ODAC products, so if you are using ODAC 10.2.0.2.20 on another Windows platform, you don't need to upgrade.


    The download includes:
    Oracle Developer Tools for Visual Studio .NET 2003 10.2.0.2.20
    Oracle Developer Tools for Visual Studio 2005 10.2.0.2.20
    Oracle Data Provider for .NET 1.x 10.2.0.2.20
    Oracle Data Provider for .NET 2.0 10.2.0.2.20
    Oracle Database Extensions for .NET 2.0 10.2.0.2.20
    Oracle Database Extensions for .NET 1.x 10.2.0.2.20
    Oracle Provider for OLE DB 10.2.0.2.20
    Oracle Objects for OLE 10.2.0.2.20
    Oracle Services for Microsoft Transaction Server 10.2.0.1.0

    Oracle Database on Windows Vista now available!

    Fri, 2007-05-04 14:27
    The 32-bit Oracle Database 10g Release 2 for Windows Vista (v. 10.2.0.3) is now available for download! It supports Vista Business, Ultimate and Enterprise Edition.

    Developers who just need the 32-bit Oracle Client for Vista can download it at that same link. This client release is much easier to install than the previous "start at 10.2.0.1 and patch up to 10.2.0.3" method that I blogged about earlier, and it doesn't require that you have access to a Metalink account (to get the patches) if you just want to evaluate the software.

    And as I mentioned in that prior blog entry, Oracle Database Express Edition has been certified on Vista for some time now.

    Some information about Oracle on 64-bit Windows Vista can be found at the Oracle Database on Windows Vista: Statement of Direction.

    Happy installing! :)

    Oracle Develop is coming to Europe and Asia! Sign up now!

    Mon, 2007-04-09 13:53
    Following up on the tremendous success of our San Francisco Oracle Develop conference, we are bringing Oracle Develop on the road to Europe and Asia in May and June. We will have in-depth technical sessions as well as hands on labs where you can get your hands dirty with the latest and greatest Oracle products.

    Click here to go to the main Oracle Develop web page to read more and to sign up.

    Here's are some of the planned .NET sessions:
    Getting Started with Oracle and .NET
    New Features in Oracle Database 11g for .NET Developers
    PL/SQL Programming for .NET Developers: Tips, Tricks, and Tools
    Best Practices for .NET Developers
    Hands-on Lab: Building .NET Applications with Oracle


    There will also be many sessions on Enterprise Java, SOA, Databases and PL/SQL, as well as Ajax, PHP, Spring, and more.

    Dates and locations:
    May 14-15 Seoul, Lotte Jamsil
    May 17-18 Bangalore, The Grand Ashok
    May 22-23 Beijing, China World Hotel
    June 18-19 Munich, Arabella Sheraton
    June 21-22 Prague, Prague Conference Center
    June 26-27 London, ExCeL


    Here's a couple photos I took at the San Francisco Oracle Develop .NET Hands on Lab, showing some pretty intense learning going on!





    See you there!

    Learn about .NET and Oracle at Collaborate07 in Las Vegas

    Thu, 2007-04-05 09:27
    The International Oracle Users Group (IOUG) will hold its Collaborate 07 conference in Las Vegas (April 15-17). If you attend, be sure to check out the .NET session and demonstration kiosk to hear more about new .NET features for Oracle Database 11g.

    Session: Oracle Database 11g: What's New for Java, JDBC, .NET, PHP, and OCI

    This session will be hosted by myself and Kuassi Mensah.

    We will also have a "Application Development Tools" booth in the exhibit hall where you can see demos of Oracle Developer Tools for Visual Studio .NET, ODP.NET and .NET Stored Procedures in Oracle, SQL Developer, Application Express, and JDBC.

    Exhibit Hall: Oracle Database 11g - Application Development Tools booth (DB-007)

    See you there!

    Pages