Useful links for C#, ASP.Net, ASP.Net MVC, SQL Server etc.

Hi friends,

In my second post I thought of publishing some the useful links across .Net,SQL Server,HTML,JQuery etc.

I'll be updating this regularly.

1.       .Net Core

·         Application essentials:  https://msdn.microsoft.com/en-us/library/xcd8txaw(v=vs.110).aspx 

·         Garbage collection :

1.       Below link has very meticulous explanation

http://www.codeproject.com/Articles/39246/NET-Best-Practice-No-Improve-garbage-collector

2.       Basics of garbage collection: http://www.codeproject.com/Articles/5362/Garbage-Collection-in-NET-A-deeper-look-for-the-be

3.        https://msdn.microsoft.com/en-us/library/f144e03t(v=vs.110).aspx

4.        https://msdn.microsoft.com/en-us/library/ms973837.aspx

2.       C Sharp

Links:

·         https://msdn.microsoft.com/en-us/library/vstudio/hh191443.aspx

·         http://blogs.msdn.com/b/pfxteam/archive/2012/04/12/10293335.aspx?Redirected=true

·         https://msdn.microsoft.com/en-us/magazine/hh456403.aspx

·         https://msdn.microsoft.com/en-us/magazine/hh456402.aspx

·         http://stackoverflow.com/questions/15148852/async-await-vs-threads

·         http://www.codeproject.com/Articles/739345/async-and-await-Simplified-Internals

      

              Videos:

·         http://channel9.msdn.com/events/Windows-8-Apps-Expert-Class/Windows-8-Apps-Expert-Class-Belgium/Async-and-Await-Tips

·         http://channel9.msdn.com/events/Visual-Studio/Visual-Studio-Live/Mads-Torgersen-ASYNC-Roslyn-and-New-Features

·         http://channel9.msdn.com/events/Windows-8-Apps-Expert-Class/Windows-8-Apps-Expert-Class-Belgium/Async-and-Await-Tips

3.       OOPs

·         Complete OOPs tutorials : http://www.codeproject.com/Articles/771455/Diving-in-OOP-Day-Polymorphism-and-Inheritance-Ear

·         OOPS concepts with examples: http://www.aspdotnet-suresh.com/2015/03/oops-object-oriented-programming-concepts-in-csharp-net-with-examples.html

·         Polymorphism : http://www.codeproject.com/Articles/771455/Diving-in-OOP-Part-Polymorphism-and-Inheritance-Ea

·         Detailed explanation for Polymorphism:

http://www.codeproject.com/Articles/602141/Polymorphism-in-NET

4.      ASP.Net

·     

·         ASP.Net Page Life Cycle

Below link gives request processing in detail

http://abhijitjana.net/2010/03/14/beginner%E2%80%99s-guide-how-iis-process-asp-net-request/

Request processing explanation from core:

http://www.west-wind.com/presentations/howaspnetworks/howaspnetworks.asp

Page events HttpModule and HttpHandler in detail

http://www.codeproject.com/Articles/73728/ASP-NET-Application-and-Page-Life-Cycle

·         Caching :
http://www.c-sharpcorner.com/UploadFile/2072a9/caching-in-Asp-Net/  

·         Understanding session management in ASP.Net – Code project : http://www.codeproject.com/Articles/416137/Understanding-Session-Management-Techniques-in-ASP

·         Globalisation and localisation in ASP.Net

http://www.codeproject.com/Articles/334820/Using-Globalization-and-Localization-in-ASP-NET

·         Globalisation and locasation in ASP.Net MVC4

http://www.codeproject.com/Articles/778040/Beginners-Tutorial-on-Globalization-and-Localizati

5.       Links for ASP.Net MVC

·         Exception handling in MVC : http://dusted.codes/demystifying-aspnet-mvc-5-error-pages-and-error-logging

·         Introduction MVC 4 tutorial : http://www.asp.net/mvc/overview/older-versions/getting-started-with-aspnet-mvc4/intro-to-aspnet-mvc-4

·         Source code for MVC

https://aspnetwebstack.codeplex.com/SourceControl/latest

6.       ASP.Net Web API

·         Web API Poster: http://www.asp.net/media/4071077/aspnet-web-api-poster.pdf

·         Web API Videos: http://www.asp.net/web-api/videos/getting-started/aspnet-web-api 

·         Web API Tutorial: http://pluralsight.com/training/Player?author=jon-flanders&name=aspnetwebapi-m1-introduction&mode=live&clip=0&course=aspnetwebapi

http://www.codeproject.com/Articles/990492/RESTful-Day-sharp-Enterprise-Level-Application 

·         Why Web API : http://www.codeproject.com/Articles/341414/WCF-or-ASP-NET-Web-APIs-My-two-cents-on-the-subjec

7.       WCF Tutorial :  http://wcftutorial.net

8.       Design Patterns

·         Design patterns : http://www.dotnet-tricks.com/Tutorial/designpatterns/NTEH250513-Gang-of-Four-(GOF)-Design-Patterns-in-.Net-.html

·         Dependency Injection and Inversion of control: http://www.mikesdotnetting.com/article/117/dependency-injection-and-inversion-of-control-with-asp-net-mvc

9.       Unit testing

·         Introducing new visual studio unit testing experience video https://channel9.msdn.com/Events/TechEd/Europe/2012/DEV214

·         Test driven development http://www.codeproject.com/Articles/472805/TestplusDrivenplusDevelopmentplus-TDD-plusinplusVi 

·         Test driven development with visual studio : https://visualstudiomagazine.com/articles/2013/07/29/test-driven-development-with-visual-studio-2012.aspx

·         Testing Web service : http://www.richard-banks.org/2008/10/unit-testing-wcf-services.html \

·         Stubs and shimps for Unit testing : https://msdn.microsoft.com/en-us/library/hh549175.aspx 

·         Test driven development with stubs in vs2012 : http://www.codeproject.com/Articles/472805/TestplusDrivenplusDevelopmentplus-TDD-plusinplusVi 

10.   TFS  

·         Microsoft design patterns and Practices TFS and otther: https://msdn.microsoft.com/en-us/library/bb668950.aspx

·         TFS for Agile development : http://blogs.msdn.com/b/visualstudiouk/archive/2012/02/01/an-introduction-to-agile-development-with-team-foundation-server-tfs-support-for-agile-practices.aspx

11.   Development Process Methodologies

·         Development models: http://sqa.fyicenter.com/FAQ/Software-Development-Models/Software_Development_Models_V_Model.html

12.  SQL Server

·         SQL Server Interview questions : http://www.aspdotnet-suresh.com/2010/05/interview-questions-in-aspnetcnetsql.html

·         Interview questions:  http://www.guru99.com/database-normalization.html

·         Sample questions : http://stackoverflow.com/questions/5728602/sql-datediff-find-datediff-between-rows  

·         http://www.c-sharpcorner.com/UploadFile/rohatash/calculate-difference-between-two-dates-of-the-same-column-or/

·         http://www.programmerinterview.com/index.php/database-sql/retrieve-unique-rows-without-distinct/

·         Top 10 steps to optimize data access in SQL Server: Part I (use indexing) – CodeProject : http://www.codeproject.com/Articles/34372/Top-steps-to-optimize-data-access-in-SQL-Server

·         Most useful links : http://social.technet.microsoft.com/wiki/contents/articles/28305.microsoft-sql-server-learning-path-and-trainings-useful-links-and-known-websites.aspx

13.   HTML5

·         Building Responsive Websites Using Twitter BootStrap: http://www.sitepoint.com/building-responsive-websites-using-twitter-bootstrap/

·         HTML5 Training : http://www.microsoftvirtualacademy.com/training-courses/learn-html5-with-javascript-css3-jumpstart-training#fbid=qJLUcU1ixna

14.   CSS Tutorial :

·         css tutorial: http://css-tricks.com

15.  JQuery

·         W3Schools : http://www.w3schools.com/jquery/

·         Official JQuery site : https://learn.jquery.com/

16.  Angularjs

·         http://www.pluralsight.com/courses/angularjs-get-started

·         http://www.pluralsight.com/courses/angularjs-dotnet-developers

·         http://www.pluralsight.com/courses/angularjs-in-depth

·         http://www.pluralsight.com/courses/angularjs-fundamentals

·         http://www.pluralsight.com/courses/angularjs-forms-bootstrap-mvc5

18.       Performance improvement

Improving .Net application performance and scalability : https://msdn.microsoft.com/en-us/library/ff649152.aspx

ASP.Net :

·         Check list ASP.Net performance : https://msdn.microsoft.com/en-us/library/ff647706.aspx

·         MSDN link : Exhaustive explanation :  https://msdn.microsoft.com/en-us/library/ff647787.aspx

Code project Links:

·         http://www.c-sharpcorner.com/uploadfile/skumaar_mca/tips-to-improve-the-performance-in-Asp-Net-application/

·         http://www.codeproject.com/Tips/263166/How-Improve-ASP-net-performence

SQL Server :

·          http://www.codeproject.com/Articles/34372/Top-steps-to-optimize-data-access-in-SQL-Server

·         Performance tuning tips : https://www.mssqltips.com/sql-server-tip-category/9/performance-tuning/

·         http://www.dotnet-tricks.com/Tutorial/sqlserver/bM6H260812-Tips-to-improve-SQL-Server-database-design-and-performance.html

·         http://www.infoworld.com/article/2628420/database/database-7-performance-tips-for-faster-sql-queries.html

·         https://msdn.microsoft.com/en-us/library/ff647793.aspx

19.       Other Useful links:

·         How to become MVP: http://www.wikihow.com/Become-a-Microsoft-MVP

·         Windows Azure: http://www.microsoftvirtualacademy.com/ebooks#azure

Thank you for reading.

Love to here your feedback.Please post your comments.

ASP.Net MVC:Basics

Hi,Thank you for reading my first post on ASP.Net MVC

Before writing anything..let me explain why we need ASP.Net MVC when we already have ASP.Net Webforms for Web development which is also

a product of Microsoft.

Why ASP.Net MVC?

Below are the uses of ASP.Net MVC.

1.Loosely coupled applications can be developed.

2.More control over the applications

3.Parallel development.

4.Easy for unit testing.


1.Loosely coupled application development

In web forms if we have to add or remove a control it will impact code behind which means there is a tight dependency between presentation layer and business layer.which is not the case with MVC where we have loosely coupled Views and Controllers and Models.

2.More control over the applications.

Means suppose we are using web forms applications we need to use controls in ASP.Net toolbox or need to create controls.
Where as in MVC,all the presentation logic can be written on our own and hence we how every piece of code reacts.

3.Parallel development.

As there is no dependency between view (Presentation uses HTML) and Controller(Busineess logic (C Sharp)).members of a team can work independently on different layers which is not at all possible in Webforms applications.

4.Easy for Unit testing.

Its easy to automate unit testing in MVC and It can be done in parallel in MVC.

Thank you for reading..