C:\Windows\System32\drivers\etc\hosts - added vstest1
I deployed C:\Users\slavk\source\repos\oratest
to J:\awww\apl\dev1\zz\zz\zdevnet which is second IIS site vstest1.
Requested URL http://vstest1:80/Default.aspx Physical Path J:\awww\apl\dev1\zz\zz\zdevnet\Default.aspx Config File \?\J:\awww\apl\dev1\zz\zz\zdevnet\web.config
Click "Start button" in the search box, enter "Turn windows features on or off" in the features window, Click: "Internet Information Services" Click: "World Wide Web Services" Click: "Application Development Features" Check (enable) the features. I checked all but CGI.
This I left untuched:
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html L:\1_instalac\1_instalirano\visual_studio_2015 1_ODTwithODAC122010_2017year.zip (9_ODTwithODAC1120320_32bit_2012year.zip did not show managed ODP.NET) oracle base dir : C:\ora_odt_odac12_2 (default shows L:\app\client\slavk) (not so C:\oraclexe\app\oracle\product\11.2.0)
oracle home (software locatuon) :
path : C:\ora_odt_odac12_2\product\12.2.0\client_1 not C:\oraclexe\app\oracle\product\11.2.0\product\11.2.0\client_1
Run the SQL scripts located in C:\ora_odt_odac12_2\product\12.2.0\client_1\ASP.NET\SQL directory after a new installation or an upgrade of Oracle Providers for ASP.NET. click win icon > type SQL (cd C:\oraclexe\app\oracle\product\11.2.0\server\bin) (does sqlplus /nolog) CONNECT SYSTEM as SYSDBA start C:\ora_odt_odac12_2\product\12.2.0\client_1\ASP.NET\SQL\InstallAllOracleASPNETProviders.sql
Database Connection Configuration A TNSNAMES.ORA file containing your connection alias has been created in C:\ora_odt_odac12_2\product\12.2.0\client_1\Network\Admin\TNSNAMES.ORA
Data Source=ora7;Persist Security Info=True;User ID=HR;Unicode=True or Data Source=XE (in tnsnames are XE and ora7) or Data Source=sspc1/XE
Oracle's ODP.net works very efficiently between Oracle and .NET and can take advantage of many of the low level features (such as bulk inserts/updates) available through the Oracle Call Interface (OCI).
From there, ODP.net has a OracleConnectionStringBuilder class that demistifys the connection string difficulties you have with most databases:
OracleConnectionStringBuilder sb = new OracleConnectionStringBuilder(); sb.DataSource = "<your datasource>"; sb.UserID = "library"; sb.Password = "library"; OracleConnection conn = new OracleConnection(sb.ToString()); conn.Open();
If your database is remote, Oracle's EZ Connect makes it nice to not have to worry about TNS names:
sb.DataSource = "hostname.whatever.com:1521/ServiceName";
VS2017 File menu > New > Project > Web > ASP.NET Web App (.NET Framework 4.6.1) C#
Name the project oratest Location: C:\Users\slavk\source\repos Solution name: oratest
MVC and chk Web forms
If you do not see the GridView Tasks pane, click the > symbol to get it
Select Database. Enter HR as the ID for the data source. Click OK.
Click New Connection...
In the Change Data Source dialog box, select Oracle Database Server as the Data Source and Oracle Data Provider for .NET as the Data Provider. Click OK.
Enter sspc1/XE (or ORCL) for Server (Data source) name, and HR for the Username and Password. Data Source=XE;Persist Security Info=True;User ID=HR;Unicode=True ? change Unicode=True to Unicode=False ? Click Test Connection
Your test was successful. Conn name is sspc1/XE.HR ConnStr11XE Click OK.
Click Next to save conn. string in app config file.
Select the EMPLOYEES table from the Name drop down. Click the checkbox in front of *. Click Next.
Click Test Query, result of your query is shown. Click Finish.
Click the Enable Paging checkbox
no support may 2018 : https://docs.microsoft.com/en-us/aspnet/core/tutorials/razor-pages/razor-pages-start?view=aspnetcore-2.1
File menu > New > Project .NET Core > ASP.NET Core Web App C#
Name the project RazorPagesMovie. It's important to name the project RazorPagesMovie so the namespaces will match when you copy/paste code. Location: C:\Users\slavk\source\repos Solution name: RazorPagesMovie
The Visual Studio template creates a starter project - see Solution explorer on right side.
Press F5 to run the app in debug mode or Ctrl-F5 to run without attaching the debugger.
VS2017 opens page http://localhost:9235/
localhostis the standard hostname for your local computer. localhost only serves web requests from the local computer. When Visual Studio creates a web project, a random port is used for the web server. When you run the app, you'll see a different port number.
The default template creates RazorPagesMovie, Home, About and Contact links and pages. Depending on the size of your browser window, you might need to click the navigation icon to show the links.
For this tutorial, Startup.cs file is the most important to understand. You don't need to review each link provided below. The links are provided as a reference when you need more information on a file or folder in the project.
File or folder Purpose wwwroot Contains static files. See Work with static files. Pages Folder for Razor Pages. appsettings.json Configuration Program.cs Hosts the ASP.NET Core app. Startup.cs Configures services and the request pipeline. See Startup.
The About, Contact and Index pages are basic pages you can use to start an app. The Error page is used to display error information.
Table 1–8 Application Programming Interfaces not supported in ODP.NET Managed Driver EF Core support is planned after .NET Core is supported. - Planned for 2019 https://apex.oracle.com/pls/apex/f?p=18357:39:3254395263557::NO::P39_ID:28241