Test-Driven Development using Cucumber

This course covers ASP.NET Core 2.0 and Visual Studio 2017. We take a detailed look at the latest APIs and development techniques for creating dynamic, modular, and testable web sites. We'll explore the new features available in ASP.NET Core and show how to get the best out of the latest toolset and integration possibilities.

Duration

3 days

Prerequisites

  • TDD and BDD essentials
  • Achieving BDD using Cucumber
  • Understanding Cucumber API and features
  • Using Cucumber with databases, DI containers, and Web/REST applications
  • Testing legacy code

What you'll learn

  • TDD and BDD essentials
  • Achieving BDD using Cucumber
  • Understanding Cucumber API and features
  • Using Cucumber with databases, DI containers, and Web/REST applications
  • Testing legacy code

Course details

Connecting to a Database and Reading Data

  • Evolution of ADO.NET
  • Managing connection strings
  • Managing connections
  • Reading data from a database
  • Connection pooling
  • Handling SQL exceptions

Executing Commands

  • Executing query and non-query commands
  • Calling stored procedures
  • Specifying parameters
  • Asynchronous queries

Transactions

  • Recap of ACID transactions
  • Managing local transactions
  • Managing distributed transactions

Using ADO.NET in GUI Applications

  • Implementing a data access layer
  • Binding data to WPF user interfaces
  • Updating the database

Disconnected Data Access

  • Populating and saving a DataSet
  • Adding, modifying, and deleting data in a DataSet
  • Using DataViews

Creating and Using Typed DataSets

  • Creating a typed DataSet
  • Managing data in a typed DataSet
  • Adding code to a typed DataSet
  • Adding queries to a typed DataSet
  • Using DataSets as XML

Getting Started with LINQ

  • Using LINQ with arrays, collections, and DataSets
  • LINQ under the hood
  • LINQ techniques
  • Performing joins

Using LINQ to SQL

  • Overview of LINQ to SQL
  • Defining relations
  • Generating mapping classes
  • Inserting, updating, and deleting entities
  • Saving changes
  • Handling optimistic concurrency conflicts

Creating an Entity Model Using the Entity Framework

  • Overview of the Entity Framework
  • Overview of entity data models
  • Defining an entity data model
  • Modifying an entity data model

Working with Data Using the Entity Framework

  • Using LINQ to Entities
  • Using Entity SQL
  • Modifying entities
  • Attaching/detaching entities