public static async Task AddTeamMembers() { List <TeamMembersModel> teamMembers = new List <TeamMembersModel>(); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN001", EmployeeName = "Gautam Sharma", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN002", EmployeeName = "Leela Bhallav Nepal", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN003", EmployeeName = "Alina Bhutia", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN004", EmployeeName = "Jaydeep Roy", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN005", EmployeeName = "Abhishek Pradhan", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN006", EmployeeName = "Sumitra Gupta", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); teamMembers.Add(new TeamMembersModel { AddedOn = DateTime.Now, EmployeeCode = "SBN007", EmployeeName = "Bheem Sharma", UpdatedOn = DateTime.Now, AddedBy = "Gautam Sharma", Designation = "Developer" }); try { await Task.Run(() => _dbContext._MyCommand.AddOrEditWithStoredProcedure("insert_teamMembers", teamMembers, null, "par_")); } catch (Exception ex) { throw new System.Exception( Common.Utilities.ErrorCodes.ProcessException(ex, "BAL", "bLocation", "SaveAllEntityValues")); } finally { _dbContext.Close_MyDbContext(); } }