Login funtionality in asp.net MVC but using MS-ACCESS

Question

Hello, I wanted to know how to use MS-ACCESS database in implementing login feature in asp.net MVC using C#. In general template of MVC it is implemented using MS-SQL but what changes I need to do so it will work with MS-Access. please reply.

Shailesh Patil · Answer

Thanks for the reply. I got it work by creating custom class for firing query and validating credentials through LoginViewModel class. But I also want to implement the functionality like in original template in which when user logs in it displays its username and logoff option. I wasnt able to do it. I just logged in and redirected to page i want. I tried changing application user and application db context classes but wasn't succeeded. Any suggestion? There may b some problem in web.config.

Pradeep Shet · Answer

Hi, No in MVC general template, it is not connected to MS-SQL. You need to create a model classes(POCO) and then map the properties of classes to data retrieved from MS-SQL(I am not talking about entity framework). To access the data from MS-ACCESS you will use oledb connection and perform the database related stuff but the result can be bound to Model and then to view manually by you. Hope you are getting my point

Login funtionality in asp.net MVC but using MS-ACCESS

Answers (2)