DB and SQL, T-SQL
- DB: Relational Data Architecture, SQL, DDL, DML
- T-SQL: Query, Advanced Query
- How-tos: Migrate Unique Columns – Ensuring Uniqueness
C# Data Access – ADO.NET
- ADO.NET: Connected Classes, Disconnected Classes
EF (Entity Framework)
- EF Basics: EDMX File Structure, Base Classes, Querying, Updating
- EF Stored Procedures: EF Queries, EF Queries w/ a Complex Type,
- EF Checklist: Consuming EF DLL, Installing EF over NuGet
EF Code First / DbContext
- EF Code First: Overview, Convention and Configurations, Data Annotation Classes, Fluent API Classes
- Code First Configuration: Databases, Tables, Convention for Properties, Configuring Properties, GUID/TimeStamp, Complex Types, Convention for Relationships, Configuring Relationships
- DbContext: Overview, DbContext, DbSet, Querying Entities, Adding/Updating/Deleting Entities, Repository Pattern
- Validation API: Single Entity, Multiple Entities, SaveChanges
- Migrations: Migrations
SOA(Service Oriented Architecture), WCF (Windows Communication Foundation)
- SOA: Service Oriented,
- WCF : Overview, Services, Clients
ASP.NET Web API
- Web API: Overview, Content Type, Action Binding, Parameter Binding, Implementing Actions, HttpResponseMessage, Views, Sessions
- HttpClent: HttpClent, Sending Data, Authentication using Session
- Others: DI with Ninject