Interview question urls

http://www.indiabix.com/technical/sql-server-general-questions/2
http://manishagrahari.blogspot.in/2011/08/abstract-factory-design-pattern.html
http://www.kodecsharp.org/examples/102.html
var authors = doc.Root.Elements().Select( x => x.Element("Author") );

http://www.a2zinterviews.com/RDBMS/sql/
http://brendan.enrick.com/post/Difference-Between-ViewBag-and-ViewData-in-MVC-3.aspx

a2zinterviews.com/DotNet/csharp.net/csharpdotnet-interview-questions_12
@@www.mindstick.com/Interview/1209/What%20are%20the%20advantages%20of%20ASP%20NET%20MVC

http://stackoverflow.com/questions/120438/whats-the-difference-between-layers-and-tiers

WCF:
http://wcftutorial.net/WCF-Instance-Management.aspx

http://www.codedigest.com/Articles/Framework/193_What_are_constructors_in_CSharp_-_A_Step_Ahead_Series.aspx
http://www.programcall.com/43/csnet/call-constructor-from-constructor-cs-this.aspx

http://chiragrdarji.wordpress.com/2007/08/23/raise-event-from-user-control-to-main-page-event-delegation-from-user-control-to-aspx-page-in-aspnetc/

Temp table Vs table variable :-
http://www.codeproject.com/Articles/42553/Quick-Overview-Temporary-Tables-in-SQL-Server-2005
Curosr:-
http://www.codeproject.com/Tips/277847/How-to-use-Cursor-in-Sql
http://stackoverflow.com/questions/9189805/creating-custom-filter-in-mvc3
//Haiving for life cycle and partial view difference
http://www.dotnet-tricks.com/Tutorial/mvc/TbR0041112-Asp.net-MVC-Request-Life-Cycle.html

Access Modifiers:-
http://karthikk.com/blog/?tag=access-modifiers
http://karthikk.com/blog/?cat=3
Polymorphism
http://javanepal.wordpress.com/2008/10/22/polymorphism-on-three-classes/
http://www.youtube.com/all_comments?threaded=1&v=4a_iTOtGhM8


http://www.dotnetfunda.com/interview/showcatquestion.aspx?start=15&page=2&category=74

Design Pattern:
http://www.abhisheksur.com/2010/05/design-patterns.html

http://www.asp.net/mvc/pluralsight

http://en.wikipedia.org/wiki/.NET_Framework

JSON Serilize:
http://forums.asp.net/t/1047490.aspx/1
http://jinaldesai.net/net-framework-version-comparision-table/

Dropdown & List in mVC 3.0
http://www.aspnetmvcninja.com/views/asp-net-mvc-select-list-example
return type in MVC
http://www.c-sharpcorner.com/UploadFile/ff2f08/actionresult-return-type-in-mvc-3-0/
http://www.dotnetjalps.com/2011/03/three-new-action-result-type-in-aspnet.html
JQUERY
http://www.dotnetfunda.com/interview/showcatquestion.aspx?start=15&page=2&category=97
http://careerride.com/jQuery-Interview-Questions.aspx#jquery1
http://tutoriz.com/Thread-JQUERY-INTERVIEW-QUESTIONS-AND-ANSWERS-SET-PDF-1-TOP-30
AJAY:-
http://www.questpondvd.com/
http://devreminder.wordpress.com/net/net-framework-fundamentals/
Craete Plugin in jQuery
http://www.9lessons.info/2011/10/how-to-create-jquery-plugin.html

Create Dropdown and DropdownlistFor
http://stackoverflow.com/questions/8182280/difference-between-dropdownlist-or-dropdownlistfor-html-helper
here are a few JavaScript frameworks/toolsets out there, such as:
 •jQuery;
 •Dojo;
 •Prototype;
 •YUI;
 •MooTools;
 •ExtJS;
 •SmartClient;
RealeaseInstanceMode

ASP>NET WHOLE WORKING:
http://www.c-sharpcorner.com/uploadfile/shivprasadk/Asp-Net-application-and-page-life-cycle/




FOR WCFs :-

http://www.codeproject.com/KB/WCF/WCFTransactions.aspx

http://www.codeproject.com/KB/WCF/WCFFAQPart5.aspx

http://www.codeproject.com/KB/aspnet/WCF.aspx

http://www.codeproject.com/KB/aspnet/WCFPart2.aspx

http://www.codeproject.com/KB/WCF/WCFFAQPart3.aspx

http://www.codeproject.com/KB/WCF/WCFTracingFAQ.aspx 


FOR MVC:-
http://www.c-sharpcorner.com/tags/1/MVC-3


datetime
date
time
datetime2
datetimeoffset
spatial

Cannot access temporary tables from within a function.
Invalid use of side-effecting or time-dependent operator in 'INSERT' within a function.

Only functions and extended stored procedures can be executed from within a function if it is a scalre funation.we can write the code of sp execution but
it will throw an error while executing the funation.

you can execute scalre funation using this query
select dbo.test()

but to execute table valued funation you have to change the your select query
select * from dbo.tablevlauedfunvname(input parameters)


you can do insert ,uopdate ,delete operation in table variables
you can call cursor from function

you cannot return multiple values from function unless it is a table variable. 

 


Thread example with completion event in it:
http://msdn.microsoft.com/en-us/library/system.componentmodel.backgroundworker.aspx


http://stackoverflow.com/questions/4409558/c-sharp-timer-run-every-5th-minute