How to create instance by string Array?

I have 15 string value. For example: excel sheet names: Customers, Products etc. these sheet,s names are the same as db Tables also Ef 4.0开发者_Python百科 Entities Name. (Products.cs, Customers.cs)

String[] excelSheets = GetExcelSheetNames(String.Format(@"C:\{0}\{1}", UserName, FileUploadForExcel.FileName));
foreach (String excelSheet in excelSheets)
 {
      GetEntity(excelSheet);
 }

protected TModel GetEntity(string ClassNameFromExcelSheetName)
{
   return(TModel)Activator.CreateInstance(ClassNameFromExcelSheetName);
}

above code is a kind of simple foresight. NOT real codes. How to create instance only using string value?

you can create instance of class by class name in string representation using .NET Reflection

Check the following article on reflection: http://www.codeproject.com/KB/dotnet/Reflection.aspx

System.Reflection.Assembly assem = Assembly.Load("");

object thisObj = assem.CreateInstance("Customers");
foreach (PropertyInfo pi in thisObj.GetType().GetProperties)
{
   // List all properties in object 
   ...
}

You probably could use some kind of Factory design pattern (http://en.wikipedia.org/wiki/Abstract_factory_pattern)

You would have to create these instances yourself, perhaps using AutoMapper.