TCL or Transaction Control Language commands are used to enforce control on transactions within a database object which might result in a change in the state of data within the dbo.
These are:
DCL or Data Control Language commands are used enforce access control to data within the database or database objects.
These are:
DML or Data Modification Language commands are used in creating, updating or deleting data from the database objects such as tables.
These are:
DDL or Data Definition Language commands are used in defining or manipulating database schema. These are used for creating, modifying, and dropping the structure of database objects such as tables.
These are:
A Singleton service instance once created is reused for the entire application lifetime, whereas a Transient service instance is created every time a calling method or dependent class requests for it from the container.
A scoped service instance is created only once within a request scope and is reused for all calls within that request.
services.AddScoped<IMyClass, MyClass>();
A transient service instance is created each time a calling component method or dependent class requests for an instance from the container.
services.AddTransient<IMyClass, MyClass>();
A singleton service instance is created only once during entire application lifetime, common across all requests.
services.AddSingleton<IMyClass, MyClass>();