Creating Rest Web Service with an existing asp.net mvc 5 app

Question

I have an existing asp.net mvc5 web application that uses the standard UserManager classes to perform authentication using the Entity Framework, so i need now to create a RESTful web service to do authentication and to store and update user details.

I'd like also to continue using the ASP.NET identity AspNetRoles table to manage the roles for user once he/she logged in.

Any idea please or do you have any links that can help me cause i'm new in the web service thing.

Answer 1

Hi,

It sound like you have version 655 but the mdf version is 661 (from MS SQL Server R2). There are couple of options.

1. upgrade your SQL Server 2008 to SQL Server 2008 R2
2. use the Generate Scripts tool to generate scripts for the database objects (abc) and run the script on your SQL server.

NOTE: You might have Microsoft SQL Server 2008 R2 Management Studio on your machine but that doesn't mean that you have Microsoft SQL Server 2008 R2

Answer 2

Right click the database, Tasks, Generate Scripts...

http://msdn.microsoft.com/en-us/library/ms178078%28v=sql.105%29.aspx

Answer 3

hi, where do we find this Generate Scripts tool to generate scripts for the database objects and plz share the link if its available. What are the steps to be followed to convert from sql server 2008 to sql server 2006 R2