Passing Datatable Parameters

Posts   
 
    
Posts: 1
Joined: 20-Jul-2016
# Posted on: 20-Jul-2016 16:24:20   

Hi,

I am using LLBL Version 4.2 Final and working with .Net 4.0 with VS 2015 and a SQL 2008 Server.

There is a stored procedure designed that requests a String, DataTable, DataTable as input Parameters. The DataTables have been defined as User-Defined Table Types that have one column defined as Ints.

USE [EMA] GO

/****** Object:  UserDefinedTableType [dbo].[INTTable]  Script Date: 7/20/2016 7:16:04 AM ******/
CREATE TYPE [dbo].[INTTable] AS TABLE(
    [INTValue] [int] NOT NULL,
    PRIMARY KEY CLUSTERED 
(
    [INTValue] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
GO

The procedure is defined as:

ALTER PROCEDURE [EMA].[LFAByPaymentTypeReport]
    @ReportDate VARCHAR(10) = NULL
    , @ClientList INTTable READONLY
    , @TypeOfPaymentMethodsList INTTable READONLY

When I run the designer and include this stored procedure it returns the types as for the parameters as String, String, String.

I tried editing the stored procedure and setting the Type to "object (System.Object)" and then it errors indicating that I need a TypeConverter. Created a generic typeconverter and it is being loaded by LLBL successfully. I added the TypeConverter in the Settings and defined the type "Rel. model data .NET Type" to System.Object and pointed to my TypeConverter.

Okay, the TypeConverter to use is always coming up as "None". I am kind of at a loss. How can I have the designer recognize the types as Datatable inputs (or at least objects) and let me pass in the correct parameter types?

Thanks in advance for any help.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 21-Jul-2016 11:35:32   

table based variables aren't supported at the moment (mainly to pass arrays to the ADO.NET provider for circumventing IN clause limits). The feature is planned for v5.1, which is currently in development. It's to be seen however we'll go as far as supporting predefined table types, but we'll take it in consideration.

Sorry I don't have better news for you.

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 26-Jan-2017 10:53:49   

This feature has been postponed to a future version/date.

Frans Bouma | Lead developer LLBLGen Pro