- Install VS 2013.
- Install ODT with ODAC 12c.
2.1. Grant role as follows.
GRANT CHANGE NOTIFICATION,
CREATE JOB,
CREATE PROCEDURE,
CREATE PUBLIC SYNONYM,
CREATE ROLE,
CREATE SESSION,
CREATE TABLE,
CREATE VIEW,
DROP PUBLIC SYNONYM,
CONNECT,
RESOURCE
TO ASPNET_DB_USER;
- Set PATH and TNS_ADMIN. If actual DB and client are in same machine, values as follows:
Required by Toad and VS.
PATH = C:\App\Oracle\Database\user\product\12.1.0\client_1
Required by listener service.
TNS_ADMIN = C:\App\Oracle\Database\user\product\11.2.0\dbhome_1\NETWORK\ADMIN
-
Install MSSQL Express.
-
Create Database=CLOSDB and User=clos.
-
Run the C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql.exe. Follow the steps with the following connection settings:
Server: QCOLIVEROS\SQLEXPRESS
Username: clos
Password: clos
Database: CLOSDB
- Change the connection string for LocalSqlServer in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config:
connectionString="Data Source=.\SQLExpress;Initial Catalog=CLOSDB;Persist Security Info=True;User ID=clos;Password=clos"
- Setup users and roles using webadmin.
8.1. Firefox settings (1 time):
8.1.1. Open up Firefox and type about:config in URL.
8.1.2. Find the Filter Type in network.automatic-ntlm-auth.trusted-uris.
8.1.3. Double click network.automatic-ntlm-auth.trusted-uris and type in localhost then hit enter.
8.2. Open cmd and run the following:
"C:\Program Files\IIS Express\iisexpress.exe" /path:"C:\Windows\Microsoft.NET\Framework\v4.0.30319\ASP.NETWebAdminFiles" /vpath:"/ASP.NETWebAdminFiles" /port:8082 /clr:4.0 /ntlm
8.3. In Firefox, type the following in URL:
http://localhost:8082/asp.netwebadminfiles/default.aspx?applicationPhysicalPath=C:\Workspace\Integro\project\dotNet\ClosDotNet\ClosDotNet&applicationUrl=/
8.4. Create users and roles.
- To switch between version, click Tools > Options > Database Tools > Data Connections > SQL Server Instance Name. The default for VS2013 is
(LocalDB)\v11.0
, change it to SQL Server 2014 Express to as(LocalDB)\MSSQLLocalDB
.
-
Create a Project: MVC + Web Api + Web Form.
-
Install the following packages:
- Common.Logging.Log4Net
Install-Package Common.Logging.Log4Net1211 -Source nuget.org
- Spring.Data.NHibernate4
Install-Package Spring.Data.NHibernate4 -Source nuget.org
- Spring.Web.Mvc4
Install-Package Spring.Web.Mvc4 -Source nuget.org
- AutoMapper
Install-Package AutoMapper -Version 3.3.1 -Source nuget.org
- Grid.MVC
Install-Package Grid.Mvc -Version 3.0.0 -Source nuget.org
- Bootstrap.Datepicker
Install-Package Bootstrap.Datepicker -Source nuget.org
- NHibernate.AspNet.Identity
Uninstall-Package Microsoft.AspNet.Identity.EntityFramework Uninstall-Package EntityFramework Install-Package NHibernate.AspNet.Identity -Source nuget.org
- foolproof
Install-Package foolproof -Source nuget.org
- WorkflowEngine.NET-ProviderForMSSQL
Install-Package WorkflowEngine.NET-ProviderForMSSQL -Source nuget.org Install-Package WorkflowEngine.NET-Designer -Source nuget.org
- Common.Logging.Log4Net
-
Add reference to the following:
- Framework > System.Transactions
- Extensions > Oracle.DataAccess
In VS, select the DLL > Right click it > In the Properties grid, select Copy Local = True