Injecting your interface at runtime with generic types.

Burak Kepti — Fri, 02 Aug 2024 19:09:11 +0000

In some situations, you need to inject your interface with unknown types. Assume that you have a main T type as a DB which you need to mark as deleted (soft delete) and need to be sure you can do the same operation for child tables. And you have one generic delete Interface for entities.

How would you call them :

`// Get your service type generically
Type serviceType = entity.CultureEntity == typeof(IDeleteBusiness<>).MakeGenericType(entity.Type);

//Get the related service from your startup.cs injection
object service = this.serviceProvider.GetRequiredService(serviceType);

//Get The method from the injected class
object? result = service
.GetType()
.GetMethod("MethodName"), [typeof(List)])?.Invoke(service, [requests]);`

All you need is to Invoke it after

How to remove duplications on TSQL

Burak Kepti — Fri, 02 Aug 2024 18:51:06 +0000

There is always a situation in which we need to remove duplications in our queries. There is an advanced way to do this for multi-purpose purpose usage. Assume that we are importing data from 3rd part source like this.

`IF OBJECT_ID(N'tempdb..#Product') IS NOT NULL
BEGIN
DROP TABLE #Product
END
create TABLE #Product (Name VARCHAR(100),Description VARCHAR(255));

INSERT INTO #Product(Name, Description) VALUES ('Entity Framework Extensions', 'Entity Framework Extensions Description.');
INSERT INTO #Product(Name, Description) VALUES ('Dapper Plus', 'Dapper Plus Description.');
INSERT INTO #Product(Name, Description) VALUES ('C# Eval Expression', 'C# Eval Description');
INSERT INTO #Product(Name, Description) VALUES ('Entity Framework Extensions', 'Entity Framework Extensions Description.');
INSERT INTO #Product(Name, Description) VALUES ('Dapper Plus', 'Dapper Plus Description.');
INSERT INTO #Product(Name, Description) VALUES ('C# Eval Expression', 'C# Eval Description');`

How we do it :

(SELECT Name ,ROW_NUMBER() over (partition by Name order by Name) RowNumber FROM #Product) a where a.RowNumber = 1;

DEV Community: Burak Kepti

Injecting your interface at runtime with generic types.

How to remove duplications on TSQL