Run an EXECUTE Operation on Business Services with Siebel
This section demonstrates how to execute an operation on a Siebel business service using the .NET Framework Data Provider for Siebel eBusiness Applications.
Executing a Siebel Business Service
This section demonstrates how to execute operations on a business service in the Siebel repository.
Caution
This example or guidance references sensitive information, such as a connection string or a username and password. Never hardcode these values in your code, and make sure that you protect confidential data by using the most secure authentication available. For more information, see the following documentation:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using System.Data;
using Microsoft.Adapters.SiebelDbProvider;
namespace SiebelADOBS
{
class Program
{
static void Main(string[] args)
{
try
{
SiebelProviderFactory factory = SiebelProviderFactory.Instance;
DbConnection connection = factory.CreateConnection();
connection.ConnectionString = "Username=SADMIN;Password=SADMIN;ServiceUri=172.23.115.223:2321;SiebelObjectManager=SSEObjMgr;SiebelEnterpriseServer=ent771;Language=enu;SiebelRepository=Siebel Repository";
connection.Open();
DbCommand command = connection.CreateCommand();
command.CommandText = "EXEC ExtractDataService.Echo @In, @InOut, @Out OUTPUT";
//Add @In
DbParameter param1 = command.CreateParameter();
param1.ParameterName = "@In";
param1.Direction = ParameterDirection.Input;
param1.Value = "SomethingElse";
command.Parameters.Add(param1);
//Add @InOut
DbParameter param2 = command.CreateParameter();
param2.ParameterName = "@InOut";
param2.Direction = ParameterDirection.InputOutput;
command.Parameters.Add(param2);
//Add @Out
DbParameter outParam = command.CreateParameter();
outParam.ParameterName = "@Out";
outParam.Direction = ParameterDirection.Output;
command.Parameters.Add(outParam);
DbDataReader dbReader = command.ExecuteReader();
Console.WriteLine("Param2: " + param2.Value);
Console.WriteLine("OutParam: " + outParam.Value);
Console.WriteLine("Press any key...");
Console.ReadLine();
}
catch (Exception exp) { Console.WriteLine(exp.Message); }
}
}
}
See Also
Use the .NET Framework Data Provider for Siebel eBusiness Applications
Run a SELECT Query on Business Components with Siebel