Click here to Skip to main content
14,743,192 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

I work in a big team and they want me to develop an extranet website and give access to couple fields of certain tables from the SQL server... And make sure the rest is fully restricted... (Does that mean I have to do repository read-only view model to get those specific columns from specific tables??)

They don't want to replicate the data to another server which involve lot security concerns.

They said to develop a web app in the middle to handle the client's requests...

Our system is all in .Net core for internal using a code first database...
They don't want the user to have to authenticate in the website... They want to get an email click a URL that writes to the database to one table and retrieve some data... And make sure the rest is fully locked down...

I am not sure on where to start and how/what to use to do that.

Any code project or advice would be more than welcome...

I know how HTTP client works basically but I am bit lost with .Net core...

I found this: and I don't know if its any help.... It does not work tho...
Build a web API with ASP.NET Core MVC and Visual Studio | Microsoft Docs[^]

And this: day 1 and day2..?
Create API with ASP.NET Core (Day 1): Getting Started and ASP.NET Core Request Pipeline[^]

Anyone else knows a project that might help me as I am not sure and it's so easy to waste precious hours...

What I have tried:

I tried to create a web API. I dont want waste too much time so I need an advice on where to put all my efforts.

1 solution


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900