Sunday, May 7, 2017

C# Delegates



Delegates are similar to interfaces. You are simply defining a contract which can be fulfilled by whatever is consuming the class that uses the delegate. The big difference between an interface and a delegate is an interface defines a contract for an entire class while a delegate defines a contract for a single method.


Array Predicate, best Example of Lambda.


A delegate is a named type that defines a particular kind of method. Just as a class definition lays out all the members for the given kind of object it defines, the delegate lays out the method signature for the kind of method it defines.
Based on this statement, a delegate is a function pointer and it defines what that function looks like.
A great example for a real world application of a delegate is the Predicate. In the example from the link, you will notice that Array.Find takes the array to search and then a predicate to handle the criteria of what to find. In this case it passes a method ProductGT10 which matches the Predicate signature.


If you're interested in seeing how the Delegate pattern is used in real-world code, look no further than Cocoa on Mac OS X. Cocoa is Apple's preferred UI toolkit for programming under Mac OS X, and is coded in Objective C. It's designed so that each UI component is intended to be extended via delegation rather than subclassing or other means.
tm
https://msdn.microsoft.com/en-us/library/d9hy2xwa.aspx

LINQ TO SQL , LINQ to Entities




  • all of them are LINQ - Language Integrated Query - so they all share a lot of commonality. All these "dialects" basically allow you to do a query-style select of data, from various sources.
  • Linq-to-SQL is Microsoft's first attempt at an ORM - Object-Relational Mapper. It supports SQL Server only. It's a mapping technology to map SQL Server database tables to .NET objects.
  • Linq-to-Entities is the same idea, but using Entity Framework in the background, as the ORM - again from Microsoft, but supporting multiple database backends
  • Linq-to-DataSets is LINQ, but using is against the "old-style" ADO.NET 2.0 DataSets - in the times before ORM's from Microsoft, all you could do with ADO.NET was returning DataSets, DataTables etc., and Linq-to-DataSets queries those data stores for data. So in this case, you'd return a DataTable or DataSets (System.Data namespace) from a database backend, and then query those using the LINQ syntax


https://weblogs.asp.net/dixin/entity-framework-core-and-linq-to-entities-1-remote-query

https://www.tektutorialshub.com/linq-to-entities-tutorial/


http://www.entityframeworktutorial.net/EntityFramework-Architecture.aspx



LINQ to SQL
It only works with SQL Server Database.
It generates a .dbml to maintain the relation
It has not support for complex type.
It cannot generate database from model.
Entity Framework
It can works with various databases like Oracle, DB2, MYSQL, SQL Server etc.
It generates an .edmx files initially. The relation is maintained using 3 different files .csdl, .msl and .ssdl
It has support for complex type.
https://sites.google.com/site/19216811wiki/ 




.NET XUNIT, NUNIT,MSTEST




Tuesday, May 2, 2017

Kotlin Tutorial










Friday, April 28, 2017

Building a RESTful API with ASP.NET Core






https://app.pluralsight.com/library/courses/asp-dot-net-core-restful-api-building/table-of-contents


Saturday, April 22, 2017

Settting up .NET core on windows 2012 R2




https://martinbuberl.com/blog/deploy-aspnet-mvc-on-amazon-ec2-with-web-deploy/



Install .NET Core

https://go.microsoft.com/fwlink/?linkid=844461

https://docs.microsoft.com/en-us/aspnet/core/publishing/iis


Install the .NET Core Windows Server Hosting bundle on the hosting system. The bundle will install the .NET Core Runtime, .NET Core Library, and the ASP.NET Core Module. The module creates the reverse-proxy between IIS and the Kestrel server. Note: If the system doesn't have an Internet connection, obtain and install the Microsoft Visual C++ 2015 Redistributable before installing the .NET Core Windows Server Hosting bundle










Sunday, March 26, 2017

Unity Architecture




http://hightalestudios.com/2017/03/game-engine-architecture-2nd-edition-overview-ch-1-part-2/



http://andrewgarrison.com/blog/jundroos-game-architecture-and-tools/






Engineering Culture






































Branching Strategy

Tuesday, March 14, 2017

MSSQL Load Testing



https://www.mssqltips.com/sqlservertip/2730/sql-query-stress-tool/


Sunday, March 12, 2017

Debugging High Memory and CPU In IIS



Windows Performance Toolkit” 8.1 update from the ADK or SDK


https://blogs.technet.microsoft.com/yongrhee/2014/05/28/wpt-updated-version-of-windows-performance-toolkit-8-1-update-from-the-adk-or-sdk/


WDK, WinDbg, and associated tools


https://developer.microsoft.com/en-us/windows/hardware/windows-driver-kit



Great Tool

https://technet.microsoft.com/en-us/sysinternals/dd996900.aspx
https://support.microsoft.com/en-us/help/2580960/debug-diagnostics-tool-v1.2-is-now-available



DOTNET TRACE
https://www.jetbrains.com/profiler/



Windows performance analyzer

https://go.microsoft.com/fwlink/p/?LinkId=536682









https://blogs.technet.microsoft.com/yongrhee/2012/11/23/wpt-wprxperf-capture-high-cpu-disk-io-file-registry-networking-private-bytes-virtual-bytes-paged-poolnonpaged-pool-andor-application-slowness/

Capture high cpu, disk i/o, file, registry, networking, Private bytes, Virtual bytes, Paged Pool/Nonpaged pool and/or application slowness.


https://blogs.technet.microsoft.com/yongrhee/2012/11/23/wpt-wprxperf-capture-high-cpu-disk-io-file-registry-networking-private-bytes-virtual-bytes-paged-poolnonpaged-pool-andor-application-slowness/







Data Analytics Platform





Mode Analytics Overview

https://vimeo.com/167591387


https://chartio.com/


https://www.quora.com/Who-has-used-Periscope-How-would-you-rate-this-tool-compared-to-Chartio


http://docs.aws.amazon.com/quicksight/latest/user/welcome.html



https://amplitude.com/
https://app.getvero.com/segments
http://docs.mparticle.com/#product-events


Testing with Sample Data









ModeAnalytics is very promising, does not show views or SP.




Data Warehousing course

SSAS , SSIS , SSRS , SSDT



https://www.visualstudio.com/vs/ssdt/


https://app.pluralsight.com/library/courses/sql-server-bi/table-of-contents

https://app.pluralsight.com/library/courses/ssis-design-patterns-data-warehousing/table-of-contents



Installing Reporting Services with default configurations

https://www.safaribooksonline.com/library/view/sql-server-2016/9781786461810/ch01s03.html


SQL Server Analysis Services (SSAS) Tutorial


https://www.mssqltips.com/sqlservertutorial/2000/sql-server-analysis-services-ssas-tutorial/






MDX Query Basics (Analysis Services 2012)



How to Install and Configure SSIS 2012








PowerBI












Building the data warehouse