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

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

#region HttpPost protected string HttpPost(string url_, string contents_, bool useCredentials_, NetworkCredential creds_) { bool isSuccess = false; int noOfRetry = 0; string response = string.Empty; try { WriteToLog(string.Format("Starting HTTPPost Publishing message {0} \r\n {1}", url_, contents_)); while (!isSuccess && noOfRetry < m_noOfRetry) { WriteToLog("HTTPPost " + "Success Status :" + isSuccess.ToString() + " Retry Count: " + noOfRetry.ToString()); Uri url = new Uri(url_); HttpWebRequest _webRequest = (HttpWebRequest)WebRequest.Create(url); _webRequest.Timeout = 400000000; _webRequest.Method = "POST"; _webRequest.ContentType = "text/xml; charset=ISO-8859-1"; _webRequest.KeepAlive = true; _webRequest.Credentials = CredentialCache.DefaultNetworkCredentials; if (useCredentials_) { string password = string.Empty; string username = string.Empty; //if no credentails provided then use if (creds_ == null) { password = ConfigurationManager.AppSettings["password"] == null ? null : ConfigurationManager.AppSettings["password"].ToString(); username = ConfigurationManager.AppSettings["user"] == null ? null : ConfigurationManager.AppSettings["user"].ToString(); if (password == null || username == null) { WriteToLog(SMSConstants.INCOMPLETE_SMSGATEWAY_INFORMATION); throw new Exception(SMSConstants.INCOMPLETE_SMSGATEWAY_INFORMATION); } WriteToLog("Connecting using UserName :" + username); password = GetDecString(password); String userInfo = username + ":" + password; byte[] bt = new byte[userInfo.Length]; bt = System.Text.Encoding.UTF8.GetBytes(userInfo); string encodedData = Convert.ToBase64String(bt); String authInfo = "Basic " + encodedData; _webRequest.Headers.Set("Authorization", authInfo);

may be you can have a look at Microsoft's Asyncronous block from MS patterns and practices. not sure. cheers varun.y.sharma@gmail.com