public PushDataWithOutputParameters ( |
||
command | ||
return | System.Data.SqlClient.SqlParameterCollection |
public void Save(ref Person person) { var command = new SqlCommand { CommandType = CommandType.StoredProcedure, CommandText = "SavePersonAndGetId" }; AddMainParameters(command, person); command.Parameters["@PersonId"].Direction = ParameterDirection.Output; SqlParameterCollection parameters = _databaseProvider.PushDataWithOutputParameters(command); int id = int.Parse(parameters["@PersonId"].Value.ToString()); person = new Person(id, person.FirstName, person.LastName, person.MiddleName, person.BirthDate); }
public void Save(ref Analysis analysis) { var command = new SqlCommand { CommandType = CommandType.StoredProcedure, CommandText = "SaveAnalysisAnGetId" }; AddMainParameters(command, analysis); command.Parameters["@AnalysisId"].Direction = ParameterDirection.Output; SqlParameterCollection parameters = _databaseProvider.PushDataWithOutputParameters(command); int id = int.Parse(parameters["@AnalysisId"].Value.ToString()); analysis = new Analysis(analysis.Template, analysis.Person, id); }