Angularjs with MSSQL Server with out webapi or entityframework

Question

User-1075244417 posted

I'm building my first Angular application with .NET.

I use VS 2015 and C# and SQL Server 2008R2.

I'm really excited about this but, despite the almost daunting amount of tutorials and docs available, I can't find a clear explanation of how to retrieve the data from SQL server and display it in my app.

I have been playing around a bit with Dan Wahlin's Customer Manager app, but this is built with Entity Framework and BreezeJS, which are both new to me.

I have also tried to follow this Code Project which builds communication with the server via a standard web service and what looks like an ajax call to retrieve some json.

However there is no server side code to deserialize the SQL into Json (which I assume is necessary).

This is what I would like:

• an example of how to connect my Angular app to SQL Server DB.
• the example should mention the steps involved to achieve that.

I don't expect a comprehensive list of all the possible ways of doing this and I'm not asking you to do it for me.

I'm just hoping for a way good enough to get me started.

Thank you very much.

Answer 1

User37182867 posted

If you are looking for quick and easy access to data then look at Linq To SQL. Its a little older and not as full featured as Entity Framework but is very easy to understand and get started with. It will also give you a jump start on EF and Linq both are very good things to understand when working with .net.

http://weblogs.asp.net/scottgu/using-linq-to-sql-part-1

Answer 2

User1444407342 posted

Hello! maybe this link help you:

http://www.infragistics.com/community/blogs/dhananjay_kumar/archive/2015/05/13/how-to-use-angularjs-in-asp-net-mvc-and-entity-framework-4.aspx

Answer 3

User1066278571 posted

Here's an example of a solution

https://damienbod.wordpress.com/2015/08/30/asp-net-5-with-sqlite-and-entity-framework-7/

You could just use an Entity Framework SQL provider instead of the SQLite provider

Greetings Damien

Answer 4

User61956409 posted

Hi arunsilivery,

This article explained how to get data in JSON format using AngularJS.

http://www.c-sharpcorner.com/UploadFile/cd7c2e/make-ajax-call-and-return-json-using-angularjs925/

However there is no server side code to deserialize the SQL into Json

Besides, in this blog, we will see how to Serialize and Deserialize the objects to JSON.

http://www.c-sharpcorner.com/Blogs/13292/serialize-and-deserialize-objects-to-json-using-C-Sharp.aspx

Best Regards,

Fei Han