How to create the project using Frontend angular 2 and .net?

Hi,

This is very acceptable approach in present times of web development.

Oracle/SQL Server DB.

.NET middleware

Aungular UI

How do they communicate?

Sample flow diagram of my project. Here SQL Server can be replaced with Oracle.

1. Setup Oracle Database.

2. Create librarary project that follows Generic reporistory pattern with entity framework and creates DB Access and DB Operation in Visual studio.

3. Create WEB API service. Web API is recommended.

WEB API Service will have project reference of class library.

Host and Expose the Web API to a URL.

4.Create Anuglar2/4 app.

5.Create a Angular2/4 service to access webAPI, create GET, PORT methods for data retrieval and updates.

6. Runt Angular service

7. Angular UI main class or anyother class will access Angular Service and service will access web api.

Also as per recent developments, I think going with ANGULAR 4 and .NET CORE would also be good idea.

You can go through detailed articles in below links -

https://www.red-gate.com/simple-talk/dotnet/net-development/working-angular-technology-stack-net/
https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/12/18/building-sql-rest-api-back-end-for-angular-apps/
http://www.c-sharpcorner.com/UploadFile/f0b2ed/oracle-database-connection-using-net/
https://www.codeproject.com/Articles/1197953/CRUD-Operation-using-ASP-NET-CORE-and-Angular-with

Hope this is helpful.

Thanks,

Tushar

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tushar Dikshit8y ago
Accepted answer
Hi,
This is very acceptable approach in present times of web development.

Oracle/SQL Server DB.
.NET middleware
Aungular UI

How do they communicate?
Sample flow diagram of my project. Here SQL Server can be replaced with Oracle.

1. Setup Oracle Database.

2. Create librarary project that follows Generic reporistory pattern with entity framework and creates DB Access and DB Operation in Visual studio.

3. Create WEB API service. Web API is recommended.
WEB API Service will have project reference of class library.
Host and Expose the Web API to a URL.

4.Create Anuglar2/4 app.
5.Create a Angular2/4 service to access webAPI, create GET, PORT methods for data retrieval and updates.
6. Runt Angular service
7. Angular UI main class or anyother class will access Angular Service and service will access web api.

Also as per recent developments, I think going with ANGULAR 4 and .NET CORE would also be good idea.

You can go through detailed articles in below links -
https://www.red-gate.com/simple-talk/dotnet/net-development/working-angular-technology-stack-net/
https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/12/18/building-sql-rest-api-back-end-for-angular-apps/
http://www.c-sharpcorner.com/UploadFile/f0b2ed/oracle-database-connection-using-net/
https://www.codeproject.com/Articles/1197953/CRUD-Operation-using-ASP-NET-CORE-and-Angular-with
Hope this is helpful.
Thanks,
Tushar
Tushar Dikshit8y ago
@ Revathi - Updated answer please check.
Revathi Parvathi8y ago
Hi Tushar Dikshit,

Thanks for your reply.Can you give some example link to me for my reference?