c# - How to create a method which takes generic list and string parameter with mapping?

Question

I have this C# working code now.

using (var bulk = new SqlBulkCopy(_connectionString))
{
    bulk.DestinationTableName = "Person";
    bulk.WriteToServer(DataTableHelper.ToDataTable(persons));
}

The problem is that the above code only applies to one table and one list object. But I have 3 more different tables and different lists that use the same code above.

Example

TableName	List Object
Person	persons
Address	address
Contact	contact

question from:https://stackoverflow.com/questions/65947258/how-to-create-a-method-which-takes-generic-list-and-string-parameter-with-mappin

Answer 1

Assuming DataTableHelper.ToDataTable() can handle a list of Person/Address/Contact, one way would be to create a generic method that takes the list of objects and the name of the table:

void WriteToServer<T>(List<T> objects, string tableName)
{
    using (var bulk = new SqlBulkCopy(_connectionString))
    {
        bulk.DestinationTableName = tableName;
        bulk.WriteToServer(DataTableHelper.ToDataTable(objects));
    }
}

Then, you can use it like this:

WriteToServer(persons, "Person");
WriteToServer(addresses, "Address");
WriteToServer(contacts, "Contact");

And if Person, Address, and Contact share the same base type (base class or an interface), then you should add a constraint to the method:

void WriteToServer<T>(List<T> objects, string tableName) where T : ISomething