PushDataWithOutputParameters() публичный Метод

public PushDataWithOutputParameters ( SqlCommand command ) : System.Data.SqlClient.SqlParameterCollection
command System.Data.SqlClient.SqlCommand
Результат System.Data.SqlClient.SqlParameterCollection
Документация по классу DatabaseProvider
Пример #1
0
        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);
        }
Пример #2
0
        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);
        }