locked
problem in built in membership system in asp.net mvc RRS feed

  • Question

  • User-179587827 posted

    i use ado.net to connect with my database. i am using built in membership system in asp.net mvc 4.5 . it does not use ado.net. i cant understand how can i show( using controller, action, view) all registered user (AspNetUsers) from this database?

    database: (__MigrationHistory, AspNetRoles, AspNetUserLogins, AspNetUserRoles, AspNetUsers)

    connection string:

      <connectionStrings>
        <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-InvitationBool-20140708042417.mdf;Initial Catalog=aspnet-InvitationBool-20140708042417;Integrated Security=True" providerName="System.Data.SqlClient" />
        <add name="InvitationDbEntities" connectionString="metadata=res://*/DataModel.csdl|res://*/DataModel.ssdl|res://*/DataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=DURLOVE-PC\DURLOVE716;initial catalog=InvitationDb;user id=sa;password=sa123456;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
      </connectionStrings>

    Sunday, July 13, 2014 9:05 PM

Answers

  • User-760709272 posted

    It's just a table in a database like any other.  Connect using the connect string and do a select from the relevant tables to show the info you need.  It's quite a simple database structure, just look at the tables and data from SQL Management Studio.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 13, 2014 9:16 PM