private static void CallStoredProc() // Вызов хранимой процедуры
{
using (var entities = new AutoLotEntities())
{
// ObjectParameter inputParameter = new ObjectParameter("CarId", 83);
var outputParameter = new ObjectParameter("petName", typeof(string));
/*int petName = */ entities.GetPetName(83, outputParameter);
Console.WriteLine("Car #83 is named {0}", outputParameter.Value);
}
}
private static void CallStoredProc()
{
using (AutoLotEntities context = new AutoLotEntities())
{
ObjectParameter input = new ObjectParameter("carID", 83);
ObjectParameter output = new ObjectParameter("petName", typeof(string));
// Call ExecuteFunction off the context....
context.ExecuteFunction("GetPetName", input, output);
// ....or use the strongly typed method on the context.
context.GetPetName(83, output);
Console.WriteLine("Car #83 is named {0}", output.Value);
}
}
private static void CallStoredProc()
{
using (AutoLotEntities context = new AutoLotEntities())
{
// 方法 #1
ObjectParameter input = new ObjectParameter("carID", 83);
ObjectParameter output = new ObjectParameter("petName", typeof(string));
// 调用上下文的ExecuteFunction方法
//context.ExecuteFunction("GetPetName", input, output);
// 方法 #2
// 或使用上下文中强类型的方法
context.GetPetName(83, output);
Console.WriteLine("Car #83 is named {0}", output.Value);
}
}
private static void CallStoredProc()
{
using (AutoLotEntities context = new AutoLotEntities())
{
//方法一
ObjectParameter input = new ObjectParameter("carID", 83);
ObjectParameter output = new ObjectParameter("petName", typeof(string));
//调用储存过程
ObjectContext objectContext = ((IObjectContextAdapter)context).ObjectContext;
objectContext.ExecuteFunction("GetPetName", input, output);
Console.WriteLine("Car #83 is named {0}.", output.Value);
//方法二
context.GetPetName(83, output);
Console.WriteLine("Car #83 is named {0}.", output.Value);
}
}
