You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
Looks like there is no support for store procedure in 2.0 alpha1.
Here is the my sample code and error for the same. Please correct me if I'm doing it wrong.
var db = Database.Open();
var results = db.ProcedureWithoutParameters();
foreach (var user in results)
{
Console.WriteLine(user.Name);
}
System.InvalidOperationException was unhandled
HResult=-2146233079
Message=Adapter returned incorrect Type.
Source=Simple.Data
StackTrace:
at Simple.Data.Commands.ExecuteFunctionCommand.ToMultipleResultSets(Object source) in d:\Code\Simple.Data\src\Simple.Data\Commands\ExecuteFunctionCommand.cs:line 37
at Simple.Data.Commands.ExecuteFunctionCommand.Execute(Object& result) in d:\Code\Simple.Data\src\Simple.Data\Commands\ExecuteFunctionCommand.cs:line 29
at Simple.Data.Database.ExecuteFunction(Object& result, ExecuteFunctionCommand command) in d:\Code\Simple.Data\src\Simple.Data\Database.cs:line 136
at Simple.Data.DataStrategy.TryInvokeFunction(String functionName, Func`1 getFunctionArguments, Object& result) in d:\Code\Simple.Data\src\Simple.Data\DataStrategy.cs:line 61
at Simple.Data.DataStrategy.TryInvokeMember(InvokeMemberBinder binder, Object[] args, Object& result) in d:\Code\Simple.Data\src\Simple.Data\DataStrategy.cs:line 71
at CallSite.Target(Closure , CallSite , Object )
at System.Dynamic.UpdateDelegates.UpdateAndExecute1[T0,TRet](CallSite site, T0 arg0)
at StoreprocedureTest.Program.Main(String[] args) in StoreprocedureTest\Program.cs:line 18
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
The text was updated successfully, but these errors were encountered:
Hi,
Looks like there is no support for store procedure in 2.0 alpha1.
Here is the my sample code and error for the same. Please correct me if I'm doing it wrong.
var db = Database.Open();
System.InvalidOperationException was unhandled
HResult=-2146233079
Message=Adapter returned incorrect Type.
Source=Simple.Data
StackTrace:
at Simple.Data.Commands.ExecuteFunctionCommand.ToMultipleResultSets(Object source) in d:\Code\Simple.Data\src\Simple.Data\Commands\ExecuteFunctionCommand.cs:line 37
at Simple.Data.Commands.ExecuteFunctionCommand.Execute(Object& result) in d:\Code\Simple.Data\src\Simple.Data\Commands\ExecuteFunctionCommand.cs:line 29
at Simple.Data.Database.ExecuteFunction(Object& result, ExecuteFunctionCommand command) in d:\Code\Simple.Data\src\Simple.Data\Database.cs:line 136
at Simple.Data.DataStrategy.TryInvokeFunction(String functionName, Func`1 getFunctionArguments, Object& result) in d:\Code\Simple.Data\src\Simple.Data\DataStrategy.cs:line 61
at Simple.Data.DataStrategy.TryInvokeMember(InvokeMemberBinder binder, Object[] args, Object& result) in d:\Code\Simple.Data\src\Simple.Data\DataStrategy.cs:line 71
at CallSite.Target(Closure , CallSite , Object )
at System.Dynamic.UpdateDelegates.UpdateAndExecute1[T0,TRet](CallSite site, T0 arg0)
at StoreprocedureTest.Program.Main(String[] args) in StoreprocedureTest\Program.cs:line 18
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
The text was updated successfully, but these errors were encountered: