AppCore snippets

app-core-single-select.cs

const string sql = "SELECT [layout_key], [layout_name] FROM [layout]";
 
var layouts = new MsSqlDataSource(_connectionString)
	.Execute(sql)
	.Select(row =>
		new Layout(
			row.GetValueOrDefault<int>("layout_key"),
			row.GetValueOrDefault<string>("layout_name")
		)
	);

execute-scalar.cs

var sqlDataSource = new MsSqlDataSource(_connectionString);
var firstId = sqlDataSource.ExecuteScalar<int>("SELECT TOP 1 id FROM Students");

get-value-to-enum.cs

var activeStatus = row.GetValueOrDefault<ProductStatus>("product_status");

longhand-sql-command.cs

var layouts = new List<Layout>();
 
using (var connection = new SqlConnection(_connectionString))
{
	try
	{
		connection.Open();
 
		const string sql = "SELECT [layout_key], [layout_name] FROM [layout]";
 
		using (var command = new SqlCommand(sql, connection))
		{
			using (var reader = command.ExecuteReader())
			{
				while (reader.Read())
				{
					var layoutKey = (int)reader["layout_key"];
					var layoutName = (string)reader["layout_name"];
 
					layouts.Add(new Layout(layoutKey, layoutName, layoutWidth));
				}
 
				return layouts;
			}
		}
	}
	catch (Exception)
	{
		// ...
	}
}

product-status-enum.cs

public enum ProductStatus
{
	[Description("a")]
	Active,

	Inactive,

	[Description("d")]
	Discontinued
}

to-enum.cs

var activeStatus = "a".ToEnum<ProductStatus>();

var inactiveStatus = "Inactive".ToEnum<ProductStatus>();