Archive Search
Rss feed GitHub Twitter Facebook LinkedIn BitBucket SoundCloud

@manhng

Welcome to my blog!

Music Store

January 13, 2022 15:00

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-odata-crud at master · telerik/kendo-examples-asp-net (github.com)

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

evilDave/MVC-Music-Store: A fork of mvcmusicstore.codeplex.com that can be deployed to Diffusyn (github.com)

SebastiaanLubbers/MvcMusicStore: MVC Music Store is a tutorial application built on ASP.NET MVC. It's a lightweight sample store which demonstrates ASP.NET MVC using Entity Framework. (github.com)

sagulati/MvcMusicStore: Old asp.net MVC Music Store sample app. (github.com)

  • net40
  • DotNetOpenAuth.OAuth
  • Microsoft.Data.OData
  • ASP.NET Membership

AlexL70/MVCMusicStore: Nothing special. Just another ASP.NET MVC Music Store application. For training purposes only. More or less the same as this http://mvcmusicstore.codeplex.com/ one. (github.com)

  • Owin
  • ASP.NET Identity

rally25rs/KendoWcfSample: Sample: Kendo UI and WCF Data Services 5.1 OData (github.com)

jesuswasrasta/MvcMusicStore: MVC Music Store is a tutorial application built on ASP.NET MVC. It's a lightweight sample store which demonstrates ASP.NET MVC using Entity Framework. (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
This project demonstrates how to perform CRUD operations using Web API and Kendo Grid for ASP.NET MVC. 

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

This link may also help

Hope this helps.

Tags: Music Store, Authentication, Authenticate, Security
Categories: Music Store | Authentication | Authenticate | Security
comment

Categories

Recent posts

Popular tags