JSON UI to SQL DB
-
Hi All, I saw many posted and infact I worked on JSON based asp.net app which use to JSONSeralizecontents and then pass that data to WEB Services on same machine and then webervice creates objects of it and call an SP with parameters on SQL and the response back to UI. now that was fine until i was on intranet where the app was open with basic username and passowrd however now I am looking for hosting this app on Internet / Cloud Machine on Amazon so my doubt is that is same Infrastructure still good since 1. I may be looking to get away with the webservice parts which reads json to create object and then use it to create SQL Command with parameters. I wish to get rid of this layer so that I can pass JSON to SQL and perform operation there itself.. or have a very light wrapper for this on web service so need suggestions on it 2. I may also be looking to secure the data which is over the internet. The app will be mainly used on PDA and Laptops Browsers so what is the best way to secure it (https, JWT or some other light weight mechanism). Also I wish to have SSO enabled for my apps. Kindly suggest.
cheers varun sharma
-
Hi All, I saw many posted and infact I worked on JSON based asp.net app which use to JSONSeralizecontents and then pass that data to WEB Services on same machine and then webervice creates objects of it and call an SP with parameters on SQL and the response back to UI. now that was fine until i was on intranet where the app was open with basic username and passowrd however now I am looking for hosting this app on Internet / Cloud Machine on Amazon so my doubt is that is same Infrastructure still good since 1. I may be looking to get away with the webservice parts which reads json to create object and then use it to create SQL Command with parameters. I wish to get rid of this layer so that I can pass JSON to SQL and perform operation there itself.. or have a very light wrapper for this on web service so need suggestions on it 2. I may also be looking to secure the data which is over the internet. The app will be mainly used on PDA and Laptops Browsers so what is the best way to secure it (https, JWT or some other light weight mechanism). Also I wish to have SSO enabled for my apps. Kindly suggest.
cheers varun sharma
So, your current application base uses username/password on an intranet, but is it leveraging Basic or Windows authentication? If you're on Windows then you're in luck, that same mechanism can work for an internet site and provide the SSO support that you're looking for.
"There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli
-
So, your current application base uses username/password on an intranet, but is it leveraging Basic or Windows authentication? If you're on Windows then you're in luck, that same mechanism can work for an internet site and provide the SSO support that you're looking for.
"There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli
Thanks for your kind reply Nathan. I am yet to start development so I shared what I knew before hand with Asp.net + JSON and sql. Finally I am looking to deploy my app on Cloud (AWS or Azure or some other basic cloud so that my customers can use it from anywhere around the world with same performance and speed over the internet). I was initially looking at AJAX + JSON with ASP.NET on front end and oracle at bank end but now i have a SQL guy who can do it better. I could either do JSON front end (with Ajax call with JSON data) -- webservice (convert JSON in .NET Object or Object) and call -- SQL Stored Proc with SQLCommend and Parameters I am looking for a better way to do it since this design is almost 8 years old, toady we have latest and better techs which I may not be well aware of son kindly suggest.
cheers varun sharma