Skip to main content

Posts

Starting an async task in C# 6 from Main

To start an async method from Main, do something like static int Main ( ) { return DoAsyncWork().GetAwaiter().GetResult(); } As of C# 7.1, can you also write static async Task< int > Main ( ) { // This could also be replaced with the body     // DoAsyncWork, including its await expressions:     return await DoAsyncWork(); } or the following if Main returns void static async Task Main ( ) { await SomeAsyncMethod(); }

POCO and Entity Framework

https://www.red-gate.com/simple-talk/dotnet/net-framework/using-entity-framework-with-an-existing-database-data-access/ https://www.red-gate.com/simple-talk/dotnet/net-framework/using-entity-framework-with-an-existing-database-data-access/

T-SQL Size used by Table and Row Counts

From: https://blog.sqlauthority.com/2017/05/25/sql-server-simple-query-list-size-table-row-counts/ USE [YourDBName] -- replace your dbname GO SELECT s. Name AS SchemaName, t. Name AS TableName, p. rows AS RowCounts, CAST (ROUND(( SUM (a.used_pages) / 128.00), 2) AS NUMERIC (36, 2)) AS Used_MB, CAST (ROUND(( SUM (a.total_pages) - SUM (a.used_pages)) / 128.00, 2) AS NUMERIC (36, 2)) AS Unused_MB, CAST (ROUND(( SUM (a.total_pages) / 128.00), 2) AS NUMERIC (36, 2)) AS Total_MB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id INNER JOIN sys.schemas s ON t.schema_id = s.schema_id GROUP BY t. Name , s. Name , p. Rows ORDER BY s. Name , t. Name GO