My first table has 'ApplicationID' as primary key which also set as identity.
All the other tables they have 'ApplicationID' as a foreign key.
In addition to this , the primary key for the other tables is
ID(of that table)+ApplicationID(of first table)
You can still do what i told you, instead of using identity, generate a unique key in your code on first page and set a session object equals to the unique key. Every time the user go back to previous page,System do a preload by using session object.
I have a web application built in Ajax. When the user opens the app we need to establish a connection (from client side) and keep it open for as long as they are active to a server on a different domain. (The domain spoof and web service work around not really an option for us).
The user as they interact with the ajax window will send data to the third party server with responses. Sometimes the third party server will send the end user updates that will need to be handled and the Ajax window updated with the new info.
I have built this in .Net2 (mandatory version) and c#. I have all the interactions working with a test hook (windows form) but now I need to move it to the web.
So do I do the painful, outdated ActiveX thing or is there a better technology to solve this. BTW The users are forced to use IE by other site requirements outside my control. I KNOW this has been done many times before so any information how others accomplish this would be greatly appreciated. JB
Silverlight is a consideration but then wouldn't I have to redo my entire app in Silverlight? This question shows my ignorance of Silverlight. I mean all my Ajax code, grids, etc would have to be recoded in Silverlight. Now if that's what it takes then that's what it takes but was hoping to avoid that...???
Yes... This is a point. But what is the problem of creating connections to your server using AJAX in a timer.. means using SetTimeOut. Does you really require to have Socket connection established and running for the entire session ?
Take for example, Gmail establishes more than one connection to their server using normal XMLHttp object and updates the Chat and mail section. Why dont you use this to update your website.
Yes. That is the rub. 3rd party forces socket connection & third party may send data realtime and we need to handle realtime. So to clarify to use Silverlight I would have to recode in silverlight or can Silverlight wrap the way Ajax modal dialog does. In other words instead of popping an Ajax window that loads a page can I pop Silverlight that loads the same page. I.E. recoding would be very minimal.