Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for Store procedure in 2.0 alpha release #387

Open
Thejas007 opened this issue Mar 28, 2016 · 0 comments
Open

Add support for Store procedure in 2.0 alpha release #387

Thejas007 opened this issue Mar 28, 2016 · 0 comments

Comments

@Thejas007
Copy link

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:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant