Asp.Net : Code first or Database first ?

Lincoln Tran — Thu, 10 Nov 2022 05:12:43 +0000

In database related programming, we can hear about 2 key words "code first - database first" when we start to design backend architecture. So, what is code/database first? Is it important in coding ?

The answer is yes, it helps you easily control model database and manages owner resource better.

Code-first

We will not create the tables under the database first, but rely on the classes/models on C# to create the database. Net supports Entity Framework Core - is an Object/Relational Mapping (O/RM) framework. It is an enhancement to ADO.NET that gives developers an automated mechanism for accessing & storing the data in the database.
The neweset EF core version is 7.0. Find out more in: https://learn.microsoft.com/en-us/ef/core/what-is-new/

In the code-first approach, EF Core API creates the database and tables using migration based on the conventions and configuration provided in your domain classes. It creates the database based on the parameter passed in the base constructor of your context class- using DB context.

Database-first

Otherwise, we already have tables under the database and we just need to create C# classes to map those tables. We also use EF build a data object model and the complete application for you with very little code.

Example:

In short, the code-database first technique in backend system design is extremely necessary for users. You will understand what system architecture you need and what is important in backend design.

Await / Async in .NET

Lincoln Tran — Fri, 04 Nov 2022 03:57:45 +0000

Hello everyone, I've worked with await/async recently but I got stuck in there . I dont know how the threads will run in system with keyword async/await?

I declare async and don't use await in the function body (it shows a warning) so is it asynchronous when calling that function?
I have 3 async functions A, B, C that I call sequentially
A
B
C
does it run asynchronously without await or need ?
await A
await B
await C
I read some Microsoft document it said "when we meet the keyword 'await', the remaining code will be non-blocking and if i think code with await will cotinue running without response's waiting, is that right?"
ex:
async A(){
await something - take 5 seconds;
call api();
}
With the above code, is it Async programming ?
Thanks all guys!!!

DEV Community: Lincoln Tran

Asp.Net : Code first or Database first ?

Code-first

Database-first

Await / Async in .NET