markrendle / Simple.Data

A light-weight, dynamic data access component for C# 4.0
MIT License
1.33k stars 303 forks source link

Add support for Store procedure in 2.0 alpha release #387

Open Thejas007 opened 8 years ago

Thejas007 commented 8 years ago

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: