The How to guide

The how-to section provides simple examples of how to work with the blocks. If you are looking for how to set up a connection, see the Getting Started section.

For the context of this section, we will use the standard Microsoft AdventureWorks database schema and SQL Server. To get the version of the database you can use go to https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure

All of the content in this section will be working within the methods inside the example AdventureWorksDataAccess.

    public class AdventureWorksDataAccess : SqlServerDataAccess
    {
        public AdventureWorksDataAccess() :
            base(new SimpleConnectionStringDataAccessConfig(
                "Server=(local);Database=AdventureWorks2019;Integrated Security=SSPI;TrustServerCertificate=True"))
        {

        }

    }

• Selecting Scalar Values
• Selecting Single Rows
• Selecting Multiple Rows
• Selecting Multiple Sets
• Execute Non-Query
• Working with Parameters
• Custom Row Translators
• Custom Column Translators

---

Table of contents

• Selecting Scalar Values
• Select Single Object
• Select To Lists
• Select To Multiple Sets
• Execute Non-Query
• Working With Parameters
• Execute Stored procedures
• Custom Row Translators