Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 04, 2012 06:07 PM by Mikesdotnetting
Mar 04, 2012 04:11 PM|LINK
1. Where can I find some jQuery examples with Razor Syntax? I'm looking to create a site that utilizes Ajax, modal popups and whatnot, where can I find examples on how to incorporate these features into my site?
2. How wise is it to use the .sdf database on fairly big sites? Let's say I have a forum with thousands of users and tens of thousands of threads, is it wise to keep using the default .sdf database? If not, can I link or migrate my data to a full blown SQL
3. Is it wise to start developing in Webmatrix/Razor from now on instead of using the regular syntax of ASP.NET in .aspx pages?
Mar 04, 2012 04:15 PM|LINK
I've done some articles on using jQuery with Web Pages. You can find them in amongst this lot:
I don't know what the limitations of SQL Compact are, but it is likely to creak at best with thoudsands of concurrent users. If you seriously expect that level of traffic, use SQL Server.
WebMatrix/Razor is just a flavour of ASP.NET development. It's fine for relatively straightforward sites. If you want to add testing, multi-developer collaboration etc, you would be better off using MVC. You can continue using Razor there.
Mar 04, 2012 04:34 PM|LINK
This looks about the right place to begin with.
Mar 04, 2012 04:53 PM|LINK
One more question, if I decided to use an SQL data connection instead of the default.sdf database, can I still use the normal SQL syntax?
Ex: select * from Table_Name...
Or do I have to use a special syntax such as ADO.NET?
Mar 04, 2012 06:07 PM|LINK
You can use SQL.
ADO.NET is a data access framework - not a syntax or language. It contains classes like DbConnection, DbCommand etc that the Database helper uses.