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
server?
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?
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.
UFO Disko
Member
51 Points
50 Posts
Couple of questions regarding WebMatrix
Mar 04, 2012 04:11 PM|LINK
Hey there,
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 server?
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?
Thank you.
Mikesdotnett...
All-Star
155597 Points
19981 Posts
Moderator
MVP
Re: Couple of questions regarding WebMatrix
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: http://www.mikesdotnetting.com/Category/28.
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.
Web Pages CMS | My Site | Twitter
UFO Disko
Member
51 Points
50 Posts
Re: Couple of questions regarding WebMatrix
Mar 04, 2012 04:34 PM|LINK
Thanks.
This looks about the right place to begin with.
http://www.mikesdotnetting.com/Article/155/WebMatrix-And-jQuery-Forms
UFO Disko
Member
51 Points
50 Posts
Re: Couple of questions regarding WebMatrix
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?
Mikesdotnett...
All-Star
155597 Points
19981 Posts
Moderator
MVP
Re: Couple of questions regarding WebMatrix
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.
Web Pages CMS | My Site | Twitter