Monthly Archives: October 2021

.NET Entity Framework Eager Loading

Posted on October 24, 2021 by chanmingman

This blog article shows you one of the way to achieve Eager Loading. As you can see in Lazy Loading https://chanmingman.wordpress.com/2021/10/17/net-entity-framework-lazy-loading/?WT.mc_id=DP-MVP-36769, it is using the WHERE clause and you cannot find the JOIN keyword. Eager loading is achieved using the … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

CTO October 2021 articles and resources

Posted on October 24, 2021 by chanmingman

These are the good reads found in this month. 10 impediments to IT innovation Inefficient IT operations Insufficient and ineffective collaboration No structure to support innovation … https://www.cio.com/article/3632930/10-impediments-to-it-innovation.html Oracle v. Google: What the verdict means for open source What copyrightable … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

Feature ‘global using directive’ is not available in C# 9.0. Please use language version 10.0 or greater

Posted on October 20, 2021 by chanmingman

This blog article shows you how to use the previous Console App template. When you create a Console App in Visual Studio 2022, I am using Preview 5, you only have one Framework available and nothing else you can choose. … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged | Leave a comment

Publish Visual Studio Database Project to SQL Server

Posted on October 17, 2021 by chanmingman

This blog article shows you how to deploy the Database project in Visual Studio to SQL Server. We reuse the Database project we created, https://chanmingman.wordpress.com/2021/10/11/import-database-schema-using-visual-studio/. We added the data by creating Post Deployment Script. To Publish the project to SQL … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server Generate Data from SQL Database to Script without Schema

Posted on October 17, 2021 by chanmingman

This blog article shows you how to generate the data from a database without generate the schema. Right click the database you want to generate the data, for example northwind, select Tasks, Select Generate Scripts… Click Next. Choose Select specific … Continue reading →

Posted in Uncategorized | Leave a comment

.NET Entity Framework Lazy Loading

Posted on October 17, 2021 by chanmingman

This short blog article shows you the example of .NET Entity Framework Lazy Loading. Lazy Loading is load on demand, it does not join. Lazy Loading known as a default loading method for Entity Framework. The code below you can … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 2 Comments

Import Database Schema using Visual Studio

Posted on October 11, 2021 by chanmingman

This blog article shows you how to import the database schema to Visual Studio. What do you want to do that? One use case is, you can then modify the schemas and deploy to another database. To import the database … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 4 Comments

Power Automate display the value of variable

Posted on October 5, 2021 by chanmingman

This blog article shows you how to display a variables in your Microsoft 365Power Automate. This is one way but you might have a better method. Below is a Instant Cloud Flow. In the first action, For a select item … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Office 365 | Tagged | Leave a comment