Last post Sep 14, 2015 03:28 PM by Abubad
Aug 27, 2015 05:53 PM|Abubad|LINK
Aug 27, 2015 06:10 PM|mostafasydney|LINK
That is, what are those development code, procedures and techniques that should not be kept in a hosted website?
The deployed site only contains binaries (dlls), configurations, scripts, front-end files etc. Source code files are not deployed to the server. Deployment tools such as Web Deploy, can determine automatically what should be deployed to the server - it includes
only those are necessary for the site to be running. The target server (IIS) need to be configured also to run the web site.
When should one consider migrating from SQL Compact CE to SQL Server?
SQL Compact CE is only for development purpose i.e. used within Visual Studio when you do the development of your sites or applications. When you finish the development you need to deploy them for testing or staging before production deployment. In test/stage
server you need to use SQL Server database as you are not using Visual Studio there, so to deploy to test server you need to migrate the database. Also at the time of production deployment you need to migrate the database as well.
Of what use is the web.config file?
Web.config is an XML file which contains all the configuration settings for the applications such as database connection strings, key-value pairs of variables used within the sites/application and other settings that are generated by the framework or plugins
that are being used. So to change any configuration, you can do it by editing the web.config file without changing any code.
Hope this will help.
Aug 28, 2015 08:10 AM|Abubad|LINK
Aug 31, 2015 01:58 PM|dblaire|LINK
Confidential info in the web.config file is not good. Usually ones save that data, such as the connection string in the App_Data folder and reference it in the web.config file.
Aug 31, 2015 02:54 PM|Mikesdotnetting|LINK
The deployed site only contains binaries (dlls), configurations, scripts, front-end files etc. Source code files are not deployed to the server.
That's not the case with Web Site projects, which is the type of project you get when you create a Web Pages site. It is possible to pre-compile a web pages site, but you can also deploy the source code files.
SQL Compact CE is only for development purpose
Aug 31, 2015 03:02 PM|Mikesdotnetting|LINK
I read a tutorial on ASP.NET that said you should always encrypt the web.config file
Aug 31, 2015 03:21 PM|wavemaster|LINK
I have some thoughts to share on SQL CE vs SQL (Express)
SQL CE is free and remains free even when the application is live. An application with CE can be hosted in a website hosting environment, and you pay only for the website hosting.
Express is free locally, it is free to use in the cloud as well, however the cost for running it hanges dramatically. You either need a Virtual Machine to run SQL (Express) or you need to pay Microsoft to use SQL Azure.
CE is lacking some of the nice features of SQL (Express), and sometimes it is a challenge to find workarounds for certain functionality.
Both SQL CE and SQL Express have limitations to the db size.
Microsoft is going through all sorts of efforts to make you a paying customer, and SQL CE does not fit in that picture. CE has been deprecated which is Microsoft lingo for we will make it difficult for you to use. Convenient and native SQL CE support was
removed from Visual Studio 2013.
There are 3rd party solutions such as SQLite / SQL Compact toolbox that work in Visual Studio 2013, but they are not as convenient as how things were in 2012.
Aug 31, 2015 03:45 PM|Mikesdotnetting|LINK
Microsoft is going through all sorts of efforts to make you a paying customer, and SQL CE does not fit in that picture.
MS have finally embraced the idea that a lot of the best solutions are already out there in Open Source Land. They have decided to work with them rather than continually expend effort on trying to compete with them. Their real revenue focus is Azure and
mobile. Even the full version of Visual Studio is free these days.
Aug 31, 2015 03:49 PM|wavemaster|LINK
SQLite does not nearly have the refinement that SQL CE has, from what little exposure I have had to it.
Sep 07, 2015 04:20 PM|Abubad|LINK
Sep 07, 2015 04:30 PM|wavemaster|LINK
When the db size reaches the limits.
When memory usage on the server is reaching its limits.
When page requests are slow.
One benefit of SQL CE is that is very easy to maintain the db, just copy the file back and forth.
SQL (Express) is a pain.
If you stick to Visual Studio 2012, SQL CE is fully supported and a publish action also updates the db.
Sep 14, 2015 03:28 PM|Abubad|LINK