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

Question

How to create the project using Frontend angular 2 and VB.net and Backend Oracle database with entity framework?.Please, any one helps me.How to connect front-end and back-end using angular 2 and Oracle database.

Tushar Dikshit · 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

Revathi Parvathi · Answer

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

Tushar Dikshit · Answer

@ Revathi - Updated answer please check.