>> Hello. Welcome. My name is diego.
I work for microsoft. I have been working at microsoft
Ten years more or less. I joined to work on the team
Called data programmability that was all about connectivity with
Databases. Since i joined, one thing i
Learned was one of our main partners was also one of our
Main competitors. It was great to work with those
Guys to try to address some of the needs of our mutual
Customers. Microsoft was different on .Net. That was the particular
Environment i worked. We were focused windows and .Net
Framework. We only care about that.
Since that, things have changed a lot.
We have created a .Net core. We have gone to a open source
And to become a platform environment and productivity,
Developer productivity platform. And guess who we met in the neighborhood?
We found it was already there on linux and in the cloud, either
Ours or theirs. Many customers wanted to use
.Net core with oracle as well it. It took some time.
We have been working together to try to make it happen.
I want to welcome christian that came all the way from
San francisco to talk to you and show you.
>> All the way. >> Yeah, all the way. Right?
>> He had to deal with problems in the airport, right?
I'm sure everyone did. >> He's going to show what they
Have been working on. >> All right.
Do i run this, then? >> i think you have that.
>> Oh, yeah, whoops. Okay. Thank you, diego.
I'm christian. I'm one of the product managers
For .Net and oracle. As he was saying, we've been
Working together both of our companies for a long time to try
To help .Net developers who are using oracle aksle.
How many of you are currently using oracle aksle in your
Day-to-day work? you're in the right place.
I'll do a demo of what we have in prerelease. That's a warning not to talk too loud.
We'll go from there. Got a demo to show you.
We'll see what happens. So starting from way back when
Microsoft introduced .Net back in 2000 -ish, we started
Providing a data provider for .Net. That's our oracle data
Managers, our
New pid. Visual studio integration, so
Things like using a designer and table adapter configuration
Wizard and also generationing sql scripts and debugging and
All that is part of our tools. You can get that on the visual
Studio marketplace. I have to mention the oracle
Cloud because we're including support for .Net core in the
Complication container cloud service now. If you get a chance to check
That out. Finally, if you write anything
Or type night or check the slides later, that's
Otn.Oracle aksle.Come/net is our landing
Page for all developers. That's where you can
Get. We have a really vibrant
Community forum on there. And videos and stuff like that.
So now let's move into the topic of the day.
Oracle data provider for .Net core. This is currently in prerelease.
You can try it out right now. I'll demo it.
You need to go to nugget. Access.Core.
Check off the rerelease box in new git to see it.
Download it from there. If you're already using the full
Regular oracle managed provider for the full framework, you'll
Notice we're using the same dll name. We're also using the same
Assembly, sorry, same name space, the same apis to some
Degree. Some things are not supported.
You'll learn about it. Then as the full framework provider.
So what it means is you can quite easily migrate what you
Already have to .Net core as long as you don't step on things
Not supported by us or .Net core itself. Right now as far as net work and
Configuration, everyone's favorite topic, we do support
Sql net. I'll show you in a second.
You can do that by using files or environment to do
It. News on the confiscation front
When we talk about features. All right.
Now's when i get to stair at my screen.
Let's switch over. All right.
So i have a zoom tool or something.
So don't fret too much if that's hard to read.
Let's go ahead and start up a new .Net console add here.
We'll call it ms build. Put it in my ms build folder so
I can find it. First thing we need to do is go
To new git and get this thing. Solution explorer.
Type in oracle. That's what i always do, anyway.
These are the -- oh, whoops.
This is the provider that's for the full framework.
And then if you scroll down, in the i've checked off the include
Prerelease tick box. Scroll down, you'll find -- whoops.
There we go. You will find the oracle manage
Data access.Core. That's really all you need.
Go ahead and install that into your project.
Let me show you something. Come in here and let me -- oh, i
Know. Let me look in my new git folder
Where my stuff gets installed.
In the normal release, we put it in a more visible location.
New entity installs these release notes.
This is very important because it has a list of what's
Supported and what's not supported in terms of features
And things like that. So come on in here and take a
Look at this. And just make sure you read
Through it when you're done installing it.
Okay. Let me -- i don't even remember
If i installed it or not. Let me check.
Yes, i did. Okay. So let me close this window.
Now, i need a little example app.
What i did was we have a nice github.
You can go to the bottom of our link we sent you.
You can go to the bottom of it and click github icon to find it
A little easier. Then in here i have sessions for
2018Ms build, data set, this is just a simple little piece of code.
But let me just copy here. This way you can follow along if
You feel like it. All right.
So here we go. So the other thing you may
Notice is that we're using that name space there using oracle
Manage data access client. Then that's really all there is
To it as far as code goes. Let's build and run it to prove
It works. Okay.
And run it. Okay.
So yeah, it does work. Let's take a look at what's
Going on in here in terms of the connection. If you take a look here, right
Now what i'm using, and this might be easier for you.
The first generation is prereleased. An easy connect connect string.
That is where you explicitly say what the host id is, the
Database listening on and the service name for the database.
In the first release, we also allow you to use tns names
Oracle files which is where your aliases are kept.
You can see here that i'm just using this alias or
Clpdb. And i think
-- I guess i don't have -- do i have a copy of it around here?
I do. Here it is.
So you can see how it's defined inside the tns names with the same information.
In any case, you'll probably be in a situation where you need to
Use tns aliases. What you can do is take the file
And you can copy it into the root or into the, let's see.
Where what did i call it? ms build.
So i can copy it in here. And now this should just run.
It should pick up the tns names and just run.
It will get you through until the next time we do a release or
The next production release p when we support configuration.
So the only last thing i want to show you while i'm into n here.
Remember i was talking about the visual studio tools?
This is what they look like. If you install oracle developer
Tools and visual studio, you get the server explorer integration
And all the good stuff. Make sure you install that too
When playing with this. Okay. I think that's my demo.
Let's go back to the slides.
Oh, i have to do it. Sorry. >> No problem.
>> Okay. Let talk about what's coming up
Here. You saw the, and if you want to
Say anything, feel free to jump in. >> Sure.
>> So what just witnessed was the prerelease.
You noticed a few things about that. I'm not showing identity
Framework core. Here i am at identity framework
With the king of identity framework here.
[Laughter] >> and we're not showing it.
It's actually not included yet. So that's going to be copping by
The end of this year. And if you are interested in
Beta testing this, write down this
Alex .Keyekeh.
Highly recommend if you're interested in this, send him an e-mail.
He'll include you in a list of a primate beta earlier than the
End of the year. Then as far as the production
Release of the oracle data provider for .Net core, we're expecting in a in the third
Quarter of this year. So that's coming right up, really.
And a couple things we'll be doing is make sure to include
Almost all features of the full framework odp.Net.
Right now we're missing some. We document that in the document
You saw. And also, we'll include api
Configuration support. What that means is you'll have
Some apis and classes you can create to basically do things
Like set up connection aliases, configure tracing, configure
Just basically anything that goes inside your app configure web config right now, that
Doesn't really exist in the .Net core world, config files.
It's up to you, i think, because you could be in lots of
Different envinements that have different ways of handling
Configuration. It's up to you to program
Adequately set that up. It's a work in progress.
We're doing everything we can to make it as easy as possible for
You. So that's what else is going to
Be in there. That's third quarter of 2018.
You want to add anything to that? >> no. Sounds great.
>> All right. How we doing on time?
Not bad at all. Okay.
So these are bitly links because the links are not copyable.
They're very long. We have a great
Odp.Net forum. It's very active and has
Questions and answers going back for ten, 15 years.
If you can think about a question, you can probably
Already find the answer in there.
I'm also on stack overflow quite a bit.
So you might see me on interest. A lot of times i'll send people here because there's so much
Great stuff there. We have a feature request page
For bigger features or things we haven't implemented yet.
You can come in here is and vote on them.
Sometimes we have to prioritize. It helpses us prioritize.
That's the feature request page. So i think we're at qa at this
Point. >> Yeah. >> So questions from the
Audience? did anyone get stuck at the
Airport? >> you got a question?
>> Do we have nay options [inaudible]
>> Okay. The question is if we have any
Options before the end of 2018 if we want to use oracle?
You say with .Net core or f core? >> [inaudible]
>> So i will let choice chan. >> Yeah. You juan a take down this guy's
Name here. Because i think much earlier
Than end of the year he's going to have something you can try.
That will get you going and learn how not only that but
Possibly, yeah, new features we might be adding will be included.
If you're interested in getting as early of a view as possible,
I'd send him an e-mail and say you'd like to be put on beta list.
>> Also, i can say this. Maybe you cannot but there is a
Third-party commercial provider or ef core for oracle.
I haven't tried it. I cannot say that it's good or bad.
But if you want to try it, if it works for you and you want to
Pay for it, it doesn't come from oracle or microsoft.
So you have to exercise your trust. >> Yeah.
>> But it exists. >> There's some major
Third-party vendors out there doing this for a fee.
So. Anybody else?
>> [Inaudible] ? >> performance. Well, we're a little early.
I don't think we've done performance metrics.
As you know, .Net core really blazes, is designed to be very fast.
I see no reason why it won't be. Plus, we're reusing a lot of the
Code already. If we weren't reusing a lot, it
Would take us a lot longer. We've already had ten to 15
Years of bark on the other provider and getting lots of
Feedback about performance. [Laughter] >> .
You know, basically fix it now. [Laughter]
>> [Inaudible] move around a lot of data and [inaudible] key thing.
[Inaudible] . >> Yeah. So you're comparing with our?
(Inaudible) the .Net framework. >> I don't see any reason why it
Would be any different and probably faster because it's
Running on .Net core. >> One piece of information is
When you release the second data of this provider, we tried it.
We have this suite of tests for es core that we run it inside.
There's a sample provider is not production but we created a
Sample provider because we wanted to verify we were not
Missing features in order to support oracle.
It ran all the tests perfectly on the first try. >> Great.
>> We switched to the .Net core provider. It was working with the
Framework but it worked. >> Wonderful to hear.
As you can tell, our groups are working very closely together.
Diego is in direct contact with all of our key engineers.
So thank you very much for your help, diego.
>> Thank you. Any more questions? okay.