Music Store (edit)
richard-coffey/MusicStore (github.com) (.NET Core)
FanHuaRan/Musicstore-ASP.NET-MVC5 (github.com) (.NET)
Continuous Delivery Project - Making MVCMusicStore Testable (tiernok.com) (Unit Testing)
kendo-examples-asp-net/grid-webapi-crud-cors at master · telerik/kendo-examples-asp-net (github.com) (CRUD WebAPI)
kendo-examples-asp-net/grid-webapi-crud at master · telerik/kendo-examples-asp-net (github.com)
kendo-examples-asp-net/grid-web-service-crud at master · telerik/kendo-examples-asp-net (github.com)
Microsoft ASP.NET MVC Music Store Tutorial
dnkato/MvcMusicStore-Tutorial: Microsoft ASP.NET MVC Music Store Tutorial (github.com)
- ASP.NET 4.6.1
- ASP.NET MVC 5.x
- ASP.NET Identity
- Owin
sagulati/MvcMusicStore: Old asp.net MVC Music Store sample app. (github.com)
- net40
- DotNetOpenAuth.OAuth
- Microsoft.Data.OData
- ASP.NET Membership
- Owin
- ASP.NET Identity
rally25rs/KendoWcfSample: Sample: Kendo UI and WCF Data Services 5.1 OData (github.com)
dmcrock/MVCMusicStore: ASP.net MVC3 music store application (github.com)
KSchlobohm/MVC-Music-Store (github.com)
FanHuaRan/Musicstore-ASP.NET-MVC5 (github.com)
- ASP.NET MVC5
- EntityFramework 6 (Code First)
ASP.Net MVC Music Store Tutorial CSS Layout issue - Stack Overflow
- StyleSheet
nickyquinn/DemoDotNetNLayer: A demo N-Tier app (github.com)
- AutoMapper
- DTO
Binding to a Web ApiController in UI for ASP.NET MVC Grid - Telerik Code Libraries
Custom Membership and Role Provider
How to configure Custom Membership and Role Provider using ASP.NET MVC | LogCorner.com (HAY HAY HAY HAY HAY)
Custom Membership with MySQL
6.2.1 Tutorial: Connector/NET ASP.NET Membership and Role Provider (oracle.com)
Oracle Providers for ASP.NET
- Oracle Developer Tools for Visual Studio
- Oracle Data Provider for .NET
- Oracle Providers for ASP.NET
The Oracle Membership Provider uses only the old MembershipProvider and does not use a UserProfile table or Oauth features.
You can install the oracle asp tables by using the SQL files included in your installation
Oracle Providers for ASP.NET Installation
Using Oracle Providers for ASP.NET
Oracle.Web.dll
ORACLE_BASE\ORACLE_HOME\ASP.NET\sql
- InstallOracleSessionState.sql (Oracle Membership Provider)
- InstallOracleRoles.sql (Oracle Role Provider)
- InstallOracleSessionState.sql (Oracle Session State Provider)
Oracle Providers for ASP.NET support this service provider mechanism allowing application state storage within an Oracle database. Existing ASP.NET provider developers will discover the Oracle Providers for ASP.NET are easy to learn and use as they share a common schema and API with existing ASP.NET providers. They integrate seamlessly with existing ASP.NET services and controls, just like other ASP.NET providers.
Oracle offers the following providers:
- Membership Provider
- Role Provider
- Site Map Provider
- Session State Provider
- Profile Provider
- Web Events Provider
- Web Parts Personalization Provider
- Cache Dependency Provider
Building Secure ASP.NET Applications
Building Secure ASP.NET Applications (purdue.edu) (eBook) (HAY HAY HAY)
Custom Membership Provider - HAY HAY HAY
Custom Membership and Role Providers - CodeProject (HAY HAY HAY HAY HAY)
How to Create Your Own Membership Provider Instead of Using SqlMembershipProvider (.NET) | Spiria (HAY HAY HAY HAY HAY)
- AspNetSqlMembershipProvider
- SqlMembershipProvider
- System.Web.Security.SqlMembershipProvider
Using Oracle Providers for ASP.NET ~ ASP.Net Examples (anagaraju.blogspot.com)
Oracle Providers for ASP.NET Installation (HAY HAY HAY HAY HAY)
ASP.NET MVC - Set custom IIdentity or IPrincipal - Stack Overflow (HAY HAY HAY HAY HAY)
Custom Membership with OLE DB and MS Access
How to configure Custom Membership and Role Provider using ASP.NET MVC | LogCorner.com
ASP.NET 2.0 Membership and Role providers for Microsoft Access (binarywater.com) (HAY HAY HAY)
View PDF file in ASP.NET MVC
.net - Pdf Viewer in MVC to show the pdf contents in View - Stack Overflow
Display (Show) PDF file embedded in View in ASP.Net MVC Razor (aspsnippets.com)
How To Open PDF File In New Tab In MVC Using C# (c-sharpcorner.com)
Create and Download PDF in ASP.NET MVC5 (completecsharptutorial.com)
asp.net - How to display PDF in div for a particular id using MVC? - QA With Experts
1.8 Oracle Providers for ASP.NET Object References
The schema in which the user runs the SQL installation script owns the tables, views, roles, stored procedures, and synonyms that the SQL script creates.
The following schema objects and their tabled information provide descriptions of what privileges each role provides, as well as the relationship between the ASP.NET service methods and the Oracle stored procedure or function.
This section lists the following objects:
1.8.1 Tables
Table 1-3 lists the tables that are used by each provider.
Table 1-3 Provider Tables
| Oracle Provider | Table |
|---|---|
|
Membership |
ora_aspnet_Membership ora_aspnet_Applications ora_aspnet_Users |
|
Role |
ora_aspnet_Roles ora_aspnet_UsersInRoles ora_aspnet_Applications ora_aspnet_Users |
|
Profile |
ora_aspnet_Profile ora_aspnet_Applications ora_aspnet_Users |
|
Personalization |
ora_aspnet_Paths ora_aspnet_PersonaliznAllUsers ora_aspnet_PersonaliznPerUser ora_aspnet_Applications ora_aspnet_Users |
|
Web Events |
ora_aspnet_WebEvents |
|
Site Map |
ora_aspnet_SiteMap ora_aspnet_Applications |
|
Session State |
ora_aspnet_SessionApplications ora_aspnet_Sessions |
1.8.2 Roles
There are, at most, three types of database roles created for each provider:
-
BasicAccess - Provides a database user with access to the provider's basic functionality.
-
ReportAccess - Provides a database user with report-oriented data gathering capabilities for a provider.
-
FullAccess - Provides a database user with access to all the database objects associated with a provider.
Table 1-4 lists the roles created for each provider.
Table 1-4 Roles and Privileges
| Oracle Provider | Oracle Database Role |
|---|---|
|
Membership |
ora_aspnet_Mem_BasicAccess ora_aspnet_Mem_ReportAccess ora_aspnet_Mem_FullAccess |
|
Role |
ora_aspnet_Roles_BasicAccess ora_aspnet_Roles_ReportAccess ora_aspnet_Roles_FullAccess |
|
Profile |
ora_aspnet_Prof_BasicAccess ora_aspnet_Prof_ReportAccess ora_aspnet_Prof_FullAccess |
|
Personalization |
ora_aspnet_Pers_BasicAccess ora_aspnet_Pers_ReportAccess ora_aspnet_Pers_FullAccess |
|
Web Events |
ora_aspnet_Wevnt_FullAccess |
|
Site Map |
ora_aspnet_Smap_FullAccess |
|
Session |
ora_aspnet_Sessn_FullAccess |
1.8.3 Views
The following tables show the views that are created for each provider. The tables also list the provider-specific database roles that provide access to these views.
1.8.3.1 OracleMembershipProvider Views
Table 1-5 lists the roles and the view access that the roles provide.
Table 1-5 OracleMembershipProvider
| Role | View |
|---|---|
|
ora_aspnet_Mem_BasicAccess |
(none) |
|
ora_aspnet_Mem_ReportAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users ora_vw_aspnet_MemUsers |
|
ora_aspnet_Mem_FullAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users ora_vw_aspnet_MemUsers |
1.8.3.2 OracleRoleProvider Views
Table 1-6 lists the roles and the view access that the roles provide.
Table 1-6 OracleRoleProvider
| Role | View |
|---|---|
|
ora_aspnet_Roles_BasicAccess |
(none) |
|
ora_aspnet_Roles_ReportAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users ora_vw_aspnet_Roles ora_vw_aspnet_UIR |
|
ora_aspnet_Roles_FullAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users ora_vw_aspnet_Roles ora_vw_aspnet_UIR |
1.8.3.3 OracleProfileProvider Views
Table 1-7 lists the roles and the view access that the roles provide.
Table 1-7 OracleProfileProvider
| Role | View |
|---|---|
|
ora_aspnet_Prof_BasicAccess |
(none) |
|
ora_aspnet_Prof_ReportAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users ora_vw_aspnet_Profiles |
|
ora_aspnet_Prof_FullAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users ora_vw_aspnet_Profiles |
1.8.3.4 OraclePersonalizationProvider Views
Table 1-8 lists the roles and the view access that the roles provide.
Table 1-8 OraclePersonalizationProvider
| Role | View |
|---|---|
|
ora_aspnet_Pers_BasicAccess |
(none) |
|
ora_aspnet_Pers_ReportAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users |
|
ora_aspnet_Pers_FullAccess |
ora_vw_aspnet_Applications ora_vw_aspnet_Users |
1.8.3.5 OracleSessionStateStore Views
Table 1-9 lists the roles and the view access that the roles provide.
Table 1-9 OracleSessionStateStore
| Role | View |
|---|---|
|
ora_aspnet_Sessn_FullAccess |
ora_vew_aspnet_sessions |
1.8.4 Stored Procedures
The following tables list provider-specific database roles and the stored procedures for which the roles provide execution privilege. The tables also list the corresponding ASP.NET service methods that invoke the stored procedures.
1.8.4.1 OracleMembershipProvider Stored Procedures
Table 1-10 lists the service methods and stored procedures that a user with the ora_aspnet_Mem_BasicAccess role can execute.
Table 1-10 ora_aspnet_Mem_BasicAccess Role
| Service Method | Stored Procedure |
|---|---|
|
GetNumberOfUsersOnline |
ora_aspnet_Mem_GetNumOfUsersOn |
|
GetPassword |
ora_aspnet_Mem_GetPassword |
|
GetUser |
ora_aspnet_Mem_GetUserByUid ora_aspnet_Mem_GetUserByName |
|
GetUserNameByEmail |
ora_aspnet_Mem_GetUserByEml |
|
UpdateUser |
ora_aspnet_Mem_UpdateUser |
|
ValidateUser |
ora_aspnet_Mem_GetPwdWithFmt ora_aspnet_Mem_UpdateUserInfo |
Table 1-11 lists the service methods and stored procedures that a user with the ora_aspnet_Mem_ReportAccess role can execute.
Table 1-11 ora_aspnet_Mem_ReportAccess Role
| Service Method | Stored Procedure |
|---|---|
|
FindUsersByEmail |
ora_aspnet_Mem_FindUsersByEml |
|
FindUsersByName |
ora_aspnet_Mem_FindUsersByName |
|
GetAllUsers |
ora_aspnet_Mem_GetAllUsers |
|
GetNumberOfUsersOnline |
ora_aspnet_Mem_GetNumOfUsersOn |
|
GetUser |
ora_aspnet_Mem_GetUserByUid ora_aspnet_Mem_GetUserByName |
|
GetUserNameByEmail |
ora_aspnet_Mem_GetUserByEml |
Table 1-12 lists the service methods and stored procedures that a user with the ora_aspnet_Mem_FullAccess role can execute.
Table 1-12 ora_aspnet_Mem_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Membership methods |
ora_aspnet_Mem_ChangePwdQAndA |
|
All Membership methods |
ora_aspnet_Mem_CreateUser |
|
All Membership methods |
ora_aspnet_Mem_FindUsersByEml |
|
All Membership methods |
ora_aspnet_Mem_FindUsersByName |
|
All Membership methods |
ora_aspnet_Mem_GetAllUsers |
|
All Membership methods |
ora_aspnet_Mem_GetNumOfUsersOn |
|
All Membership methods |
ora_aspnet_Mem_GetPassword |
|
All Membership methods |
ora_aspnet_Mem_GetPwdWithFmt |
|
All Membership methods |
ora_aspnet_Mem_GetUserByEml |
|
All Membership methods |
ora_aspnet_Mem_GetUserByName |
|
All Membership methods |
ora_aspnet_Mem_GetUserByUid |
|
All Membership methods |
ora_aspnet_Mem_ResetPassword |
|
All Membership methods |
ora_aspnet_Mem_SetPassword |
|
All Membership methods |
ora_aspnet_Mem_UnlockUser |
|
All Membership methods |
ora_aspnet_Mem_UpdateUser |
|
All Membership methods |
ora_aspnet_Mem_UpdateUserInfo |
|
All Membership methods |
ora_aspnet_Users_DeleteUser |
1.8.4.2 OracleRoleProvider Stored Procedures
Table 1-13 lists the service methods and stored procedures that a user with the ora_aspnet_Roles_BasicAccess role can execute.
Table 1-13 ora_aspnet_Roles_BasicAccess Role
| Service Method | Stored Procedure |
|---|---|
|
GetRolesForUser |
ora_aspnet_UIR_GetRolesForUser |
|
IsUserInRole |
ora_aspnet_UIR_IsUserInRole |
Table 1-14 lists the service methods and stored procedures that a user with the ora_aspnet_Roles_ReportAccess role can execute.
Table 1-14 ora_aspnet_Roles_ReportAccess Role
| Service Method | Stored Procedure |
|---|---|
|
FindUsersInRole |
ora_aspnet_UIR_FindUsersInRole |
|
GetAllRoles |
ora_aspnet_Roles_GetAllRoles |
|
GetRolesForUser |
ora_aspnet_UIR_GetRolesForUser |
|
GetUsersInRole |
ora_aspnet_UIR_GetUsersInRoles |
|
IsUserInRole |
ora_aspnet_UIR_IsUserInRole |
|
RoleExists |
ora_aspnet_Roles_RoleExists |
Table 1-15 lists the service methods and stored procedures that a user with the ora_aspnet_Roles_FullAccess role can execute.
Table 1-15 ora_aspnet_Roles_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Role Manager methods |
ora_aspnet_Roles_CreateRole |
|
All Role Manager methods |
ora_aspnet_Roles_DeleteRole |
|
All Role Manager methods |
ora_aspnet_Roles_GetAllRoles |
|
All Role Manager methods |
ora_aspnet_Roles_RoleExists |
|
All Role Manager methods |
ora_aspnet_UIR_AddUsersToRoles |
|
All Role Manager methods |
ora_aspnet_UIR_FindUsersInRole |
|
All Role Manager methods |
ora_aspnet_UIR_GetRolesForUser |
|
All Role Manager methods |
ora_aspnet_UIR_GetUsersInRoles |
|
All Role Manager methods |
ora_aspnet_UIR_IsUserInRole |
|
All Role Manager methods |
ora_aspnet_UIR_RemUsersFmRoles |
1.8.4.3 OracleProfileProvider Stored Procedures
Table 1-16 lists the service methods and stored procedures that a user with the ora_aspnet_Prof_BasicAccess role can execute.
Table 1-16 ora_aspnet_Prof_BasicAccess Role
| Service Method | Stored Procedure |
|---|---|
|
GetPropertyValues |
ora_aspnet_Prof_GetProperties |
|
SetPropertyValues |
ora_aspnet_Prof_SetProperties |
Table 1-17 lists the service methods and stored procedures that a user with the ora_aspnet_Prof_ReportAccess role can execute.
Table 1-17 ora_aspnet_Prof_ReportAccess Role
| Service Method | Stored Procedure |
|---|---|
|
GetAllProfiles |
ora_aspnet_Prof_GetProfiles |
|
GetAllInactiveProfiles |
ora_aspnet_Prof_GetProfiles |
|
GetNumberOfInactiveProfiles |
ora_aspnet_Prof_GetNumOfInactPf |
|
FindProfilesByUserName |
ora_aspnet_Prof_GetProfiles |
|
FindInactiveProfilesByUserName |
ora_aspnet_Prof_GetProfiles |
Table 1-18 lists the service methods and stored procedures that a user with the ora_aspnet_Prof_FullAccess role can execute.
Table 1-18 ora_aspnet_Prof_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Profile methods |
ora_aspnet_Prof_DeleteInactPf |
|
All Profile methods |
ora_aspnet_Prof_DeleteProfiles |
|
All Profile methods |
ora_aspnet_Prof_GetNumOfInactPf |
|
All Profile methods |
ora_aspnet_Prof_GetProfiles |
|
All Profile methods |
ora_aspnet_Prof_GetProperties |
|
All Profile methods |
ora_aspnet_Prof_SetProperties |
1.8.4.4 OraclePersonalizationProvider Stored Procedures
Table 1-19 lists the service methods and stored procedures that a user with the ora_aspnet_Pers_BasicAccess role can execute.
Table 1-19 ora_aspnet_Pers_BasicAccess Role
| Service Method | Stored Procedure |
|---|---|
|
LoadPersonalizationState |
ora_aspnet_PPU_GetPgSettings ora_aspnet_PAU_GetPgSettings |
|
ResetPersonalizationState |
ora_aspnet_PPU_ResetPgSettings ora_aspnet_PAU_ResetPgSettings |
|
SavePersonalizationState |
ora_aspnet_PPU_SetPgSettings ora_aspnet_PAU_SetPgSettings |
Table 1-20 lists the service methods and stored procedures that a user with the ora_aspnet_Pers_ReportAccess role can execute.
Table 1-20 ora_aspnet_Pers_ReportAccess Role
| Service Method | Stored Procedure |
|---|---|
|
FindState |
ora_aspnet_PA_FindState |
|
GetCountOfState |
ora_aspnet_PA_GetCountOfState |
Table 1-21 lists the service methods and stored procedures that a user with the ora_aspnet_Pers_FullAccess role can execute.
Table 1-21 ora_aspnet_Pers_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Personalization methods |
ora_aspnet_PA_FindState |
|
All Personalization methods |
ora_aspnet_PA_GetCountOfState |
|
All Personalization methods |
ora_aspnet_PA_ResetSharedState |
|
All Personalization methods |
ora_aspnet_PA_ResetUserState |
|
All Personalization methods |
ora_aspnet_PAU_GetPgSettings |
|
All Personalization methods |
ora_aspnet_PAU_ResetPgSettings |
|
All Personalization methods |
ora_aspnet_PAU_SetPgSettings |
|
All Personalization methods |
ora_aspnet_PPU_GetPgSettings |
|
All Personalization methods |
ora_aspnet_PPU_ResetPgSettings |
|
All Personalization methods |
ora_aspnet_PPU_SetPgSettings |
1.8.4.5 OracleWebEventProvider Stored Procedures
Table 1-22 lists the service methods and stored procedures that a user with the ora_aspnet_Wevnt_FullAccess role can execute.
Table 1-22 ora_aspnet_Wevnt_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Web Event methods |
ora_aspnet_LogWebEvents |
1.8.4.6 OracleSiteMapProvider Stored Procedures
Table 1-23 lists the service methods and stored procedures that a user with the ora_aspnet_Smap_FullAccess role can execute.
Table 1-23 ora_aspnet_Smap_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Site Map methods |
ora_aspnet_GetSiteMapData |
1.8.4.7 OracleSessionStateStore Provider Stored Procedures
Table 1-24 lists the service methods and stored procedures that a user with the ora_aspnet_Sessn_FullAccess role can execute.
Table 1-24 ora_aspnet_Sessn_FullAccess Role
| Service Method | Stored Procedure |
|---|---|
|
All Session State methods |
ora_aspnet_SessnApp_SetAppID |
|
All Session State methods |
ora_aspnet_Sessn_InsUninitItem |
|
All Session State methods |
ora_aspnet_Sessn_RelStateItmEx |
|
All Session State methods |
ora_aspnet_Sessn_RmStateItem |
|
All Session State methods |
ora_aspnet_Sessn_ResetTimeout |
|
All Session State methods |
ora_aspnet_Sessn_UpdStateItem |
|
All Session State methods |
ora_aspnet_Sessn_InsStateItem |
|
All Session State methods |
ora_aspnet_Sessn_GetStateItem |
|
All Session State methods |
ora_aspnet_Sessn_GetStateItmEx |
1.8.5 Synonyms
Public synonyms are created for all stored procedures so that they can be executed by any user in the database who is granted proper provider-specific roles by the user that owns the stored procedures.
ASP.NET Membership
Create And Install ASP.NET Membership Database (c-sharpcorner.com)
.NET Membership in ASP.NET MVC4 and Entity Framework with Oracle as Db
I am using Oracle Developer Tools for .NET (ODT), and it has been a great help. The best part: it's free! ODT includes ODP.NET and will help you do the following:
- automatically set up ASP.NET membership tables. You'll need to create the schema first, then run the scripts provided.
- automatically create and map EF entities (using database first); you will not need to manually map tables to tables.
Some things to consider... My membership schema is separate from the schemas used for my application. This way I can use one membership schema for several applications that may rely on different databases (schemas/users).
When configuring web.config, be sure to change the application name from "/" to something meaningful. Several config elements reference the application name, so be sure to change for all. The membership provider will automatically create the application record in the membersip database schema.
After your membership schema has been created (with the scripts), you'll need to change the web.config file's membership, profile, and roleManager elements to something like this:
<membership defaultProvider="OracleMembershipProvider">
<providers>
<clear />
<add name="OracleMembershipProvider" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConnectionString" applicationName="YOUR_APP_NAME" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<clear />
<add name="OracleProfileProvider" type="Oracle.Web.Profile.OracleProfileProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConnectionString" applicationName="YOUR_APP_NAME" />
</providers>
</profile>
<roleManager enabled="true" defaultProvider="OracleRoleProvider">
<providers>
<clear />
<add connectionStringName="OraAspNetConnectionString" applicationName="YOUR_APP_NAME" name="OracleRoleProvider" type="Oracle.Web.Security.OracleRoleProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</providers>
</roleManager>
Hope this helps.
