public void GeneralTestMethod() { // Some things should be done before running this test method: // // - Configure the EF and the ConnectionString in the App.config // - Create a new database table // - Create a new data model and a new mapping configuration that represent the database table // - Add this configuration to the DbContext configurations // - Change the list type below in order to use the data model type that has been created in the previous steps // - Change the update SQL below in order to update your data var entities = new List <object>(); // Or you can construct your DataTable by another way var dataTable = entities.AsStronglyTypedDataTable(); using (var sqlService = new SqlService()) { sqlService.BulkInsert(dataTable); sqlService.BatchUpdate(dataTable, string.Empty); } }