WYSIWYG md editor SimpleMDE or use some desktop markdown text editor    Home    [ html2markdown ]
Markdown txt 01/006_visual_studio/Cre_ASP.NETWebForms_or_Razor_webap.txt Parsedown-ed to HTML.    [ Edit text ]    [ Colored text ]

http://vstest1/Default.aspx 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: https://docs.microsoft.com/en-us/iis/get-started/planning-for-security/how-to-use-locking-in-iis-configuration %windir%\system32\inetsrv\config\applicationHost.config configSections
overrideModeDefault="Allow" ...


  1. Create a ASP.NET web site
  2. Create a GridView
  3. Create a new Data Source
  4. Execute your web site

1. Create ASP.NET MVC & Web Forms web project

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) : name :
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());

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

2. Creating GridView

  1. In the Default.aspx tabbed page, click the Design tab
  2. You get a blank canvas
  3. From View menu, select Toolbox
  4. Scroll down. In the toolbox, expand Data. Drag the GridView control to the Design area

3. Creating Data Source

  1. If you do not see the GridView Tasks pane, click the > symbol to get it Select from the Choose Data Source drop down. A Data Source Configuration wizard starts.

  2. Select Database. Enter HR as the ID for the data source. Click OK.

  3. Click New Connection...

  4. 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.

  5. 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

  6. Your test was successful. Conn name is sspc1/XE.HR ConnStr11XE Click OK.

  7. Click Next to save conn. string in app config file.

  8. Select the EMPLOYEES table from the Name drop down. Click the checkbox in front of *. Click Next.

  9. Click Test Query, result of your query is shown. Click Finish.

  10. Click the Enable Paging checkbox

4. Executing your Web Site - run ASP.NET web app

  1. Build > Build Web Site
  2. ctrl+F5 or F5 (Debug > Start Debugging)
  3. If F5 Click OK to modify the web.config file to enable debugging. Web browser will open showing web app. http://localhost:41578/Default

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

Web App

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/

  1. Visual Studio starts IIS Express and runs your app. localhost is 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.
  2. Launching the app with Ctrl+F5 (non-debug mode) allows you to make CRUD page. Use non-debug mode to quickly launch the app and view changes.

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.

Project files and folders

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.

Pages folder

  1. _Layout.cshtml file contains common HTML elements (scripts and stylesheets) and sets the layout for the application. For example, when you click on RazorPagesMovie, Home, About or Contact, you see the same elements. The common elements include navigation menu on the top and the header on the bottom of the window. See Layout for more information.
  2. _ViewStart.cshtml sets the Razor Pages Layout property to use the _Layout.cshtml file. See Layout for more information.
  3. _ViewImports.cshtml file contains Razor directives that are imported into each Razor Page. See Importing Shared Directives for more information.
  4. _ValidationScriptsPartial.cshtml file provides a reference to jQuery validation scripts. When we add Create and Edit pages later in the tutorial, the ValidationScriptsPartial.cshtml file will be used.

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.

L:\1_instalac\1_instalirano\visual_studio_2015\oracle\Oracle_data_provider_for_NET_e55744.pdf https://docs.oracle.com/cd/E56485_01/win.121/e55744/toc.htm

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