If you want to get a free copy of the Index, Table of Contents and of Chapter 1, have a look here. Click on the READ AN EXCERPT dropdown and then select the one you would like to review. Figure 1 illustrates how that looks like. Figure 1, how to get a free PDF copy […]
Read More →I am proud to announce the publication of my newest book titled, “Microsoft Certified Associate Data Engineer Study Guide” for the DP-203 exam. The example data used in this book consists of my brainwaves. You can download the data and the source code for all the examples in the book on GitHub here . ADLS, […]
Read More →
I am updating, or should I say, re-coding a website I have from ASP.NET Web Forms (aspx) to ASP.NET Core Razor Pages (chtml). The database it connects to only has a global admin, full access user identity. So I thought that I would fix that and create a need account for read only access. This […]
Read More →With the recent introduction of so many ORM’s (Object-relational mapping) tools onto the market it is becoming less and less needful to write SQL statements. Tools like NHibernate, Entity Framework and SubSonic to name a few will take your database mappings and write an optimized query for you. However, during development, testing or production support […]
Read More →
In Lesson 14 you will learn how to: Create a SQL Server database from Visual Studio Create the database table using NHibernate SchemaExport Create a WCF which uses NHibernate Create a SilverLight 5.0 application Populate SilverLight 5.0 DataGrid
Read More →
In Lesson 13 you will learn how to: Install and reference NHibernate 3.2 Beta 1 Create a SQL Server 2008 database Create NHibernate entities using Mapping by Code Create a strongly-typed NHibernate configuration Use SchemaExport and SchemaValidate to create tables and relationships Insert and retrieve data
Read More →
In Lesson 5 you will learn how to: Add a foreign key relationship in SQL Server Create a Class in C# Create a Stored Procedure Create and configure a child Gridview Call a method of a class Handle NULL exceptions
Read More →
In Lesson 3 you will learn how to: Create a new windows form application Create a Disconnected DataSet, DataAdapter, DataSchema, DataTable and DataColumn Insert, Update and Delete data within the DataSet Save the changes made to the DataSet to the database Reject the changes made to the DataSet Filter data within the GridView
Read More →
In Lesson 1 you will learn how to: Create a SQL Server Database Create a table, populate it with data and select primary key Create a new ASP.NET application Create a database connection manager Create the database layer within a Data Access Component Create a gridwiew to display the data
Read More →