Friday, September 22, 2017

ASP.NET Data Tutorial 35 Parts with updated Visual Studio 2010 C# project

ASP.NET Data Tutorial - 3-tier Architecture in ASP.NET 2.0 -Classic Example


The is a very old but classic ASP.NET 2.0 Data Tutorial (2006) introduced a 3-tier architecture composed of a Data Access Layer (DAL) using Typed DataSets, a Business Logic Layer (BLL) that enforces custom business rules, and a presentation layer composed, in this case ASP.NET pages. This very detailed tutorial with 35 chapters still holds up and is a great historical reference, and is here for record. It is the foundation for modern architectures using Object/Relational Mapping (O/RM) such as Entity Framework.  Here's an intro Getting Started with Entity Framework 6 Code First using MVC 5

Some links are now beginning to disappear. Mainly, all the code files such as ASPNET_Data_Tutorial_1_CS.exe, ASPNET_Data_Tutorial_2_CS.exe, etc are unavailable to download.

Below is a download of all original code and PDF of all the chapters for your convenience.



Tutorial 2 : The BLL Separates the Presentation Layer from the Data Access Layer and Imposes Business Rules - 3ish Tier Architecture

Here is a diagram of a full blown modern n-tier approach applied to an ASP.NET MVC application using Entity Framework:




Back to ASP.NET 2.0 example here's  the presentation layer with it's classy sophisticated design :)


Tutorial 4 : The FormView Must Include an ItemTemplate
































Download Chapters 1-35  in a single PDF ASPNET_Data_Tutorial_PDF_ALL_Chapters.PDF.


Download the ASPNET_Data_Tutorial_1_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_2_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_3_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_4_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_5_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_6_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_7_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_8_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_9_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_10_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_11_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_12_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_13_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_14_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_15_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_16_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_17_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_18_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_19_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_20_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_21_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_22_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_23_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_24_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_25_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_26_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_27_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_28_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_29_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_30_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_31_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_32_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_33_CS.exe sample code. Rolled-up into 35.
Download the ASPNET_Data_Tutorial_34_CS.exe sample code. Rolled-up into 35.

Download the ASPNET_Data_Tutorial_35_CS.exe* sample code. 

*Downloads ASPNET_Data_Tutorial_35_CS_VS2010_Working.zip, which is original code wrapped in a Visual Studio 2010 Project and original code working with SQL Server 2012 Developer Edition (a minor connection string change). Zip is safer that self-extracting exe.

Thursday, September 21, 2017

.NET Conf 2017 Beginner Day 3 Free Microsoft Training

Today is beginner day for Microsoft .NET Conf 2017. Free training for .NET Fundamentals (Track 1) and Mobile/Web (Track 2) with code samples available live on https://channel9.msdn.com/ from 9PM-5PM PDT. 


Wednesday, September 20, 2017

CCleaner malware affected 2 Billion users, use alternative BleachBit instead




Now this is an ironic, Avast anti-virus company distributed the infected CCleaner.

CCleaner (short for Crap Cleaner) is a popular utility tool , which promises to clean up your system for enhanced performance, was hacked to distribute malware directly to its users, Cisco Talos reports.

For a period of time, the legitimate signed version of CCleaner 5.33 being distributed by Avast also contained a multi-stage malware payload that rode on top of the installation of CCleaner

CCleaner boasted over 2 billion total downloads by November of 2016 with a growth rate of 5 million additional users per week. Given the potential damage that could be caused by a network of infected computers even a tiny fraction of this size we decided to move quickly. On September 13, 2017 Cisco Talos immediately notified Avast of our findings so that they could initiate appropriate response activities. The following sections will discuss the specific details regarding this attack.


Full details from Talos http://blog.talosintelligence.com/2017/09/avast-distributes-malware.html

Alternative


A great and free alternative is BleachBit a new open-source privacy cleaner tool. 

Download open source BleachBit at 
http://bleachbit.sourceforge.net/


Use 

I wrote a blog post on how to clean re-spawning Adobe cookies using BleachBit.
How to Delete Google Chrome Adobe Flash Cookies (.sol files) - Respawning Cookies