NO on both counts.... You WILL need some components when you deploy as with any other software built with .Net and using external libraries. You need Azure SDk only if you are planning to use Azure or deploy on Azure (In fact, to just deploy, you don't NEED Azure tools, but it make it so much easier that it would be ridiculous to not use it.)
Bernard Grosperrin BGSoftFactory
That's what I meant. Maybe I would add that it might also be an advantage for all those who "think" they know what they are doing, but don't....:cool:
Bernard Grosperrin BGSoftFactory
Seems difficult to give you a precise answer without knowing more about the database. From my point of view, but I might be biased as I come more from a SQL background than many, I would create a SQL View, taking parameters (stored procedure) returning all ClassRooms available between 2 datetime (start and end), and I would do my select against this view. Also, as I guess classes starts and end at a fixed hour, instead of using a whole datetime twice, I would build a fixed table with ID values, for example, from 8 to 8:45 AM = #1, from 9 to 9:45 = #2, and so on... Just some ideas....
Bernard Grosperrin BGSoftFactory
Ramkumar_S wrote:
Is azure support multitenant by itself or we need to create in web application?
I am not 100% sure what you mean by this, but I suggest you get a bit more familiar with Azure, as it's not only Web sites. In fact, I don't see why you could not just port what you already have to Azure, THEN see if you want to switch to an SAAS model.
Bernard Grosperrin BGSoftFactory
"Is azure support multitenant by itself or we need to create in web application?" I am not sure to fully understand what you mean, but you may need to explore Azure a little more, as Azure is not only web sites and web applications. In fact, I see no reasons to not port what you already have "as is" on Azure, THEN see if you want to switch to an SAAS model.
Giuseppe Tollini wrote:
you don't have any control over security
From my point of view, this could be in the advantage column as well as in the disadvantages.....
Bernard Grosperrin BGSoftFactory
I read this just now, I would have reacted immediately otherwise. Compact SQL works just fine on Azure. You just need to deploy the proper DLLs. I have a site (test) working fine with it. Now, another question would be, beside "working", to ask if SQl Compact is "adapted" to Azure, and the answer would be NO! Simply because, beside working, you need to be able to follow easily the main feature of Azure, which is scaling (up or down) by creating instances of your site. Compact being purely local, you would end up having as many DBs as Instances, which is not great.....