Column is defined in entity as Boolean.
TXDataWebDataSet sees it as boolean.
When inserting or updating a record an error is generated saying...
{
"error": {
"code": "AureliusOdbcException",
"message": "Error -1: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'T' to data type bit."
}
}
SQL Trace shows the following...
declare @p1 int
set @p1=NULL
exec sp_prepexec @p1 output,N'@P1 nvarchar(24),@P2 nvarchar(5),@P3 nvarchar(1),@P4 nvarchar(1),@P5 nvarchar(1),@P6 nvarchar(1),@P7 int,@P8 nvarchar(3),@P9 int,@P10 nvarchar(5)',N'SET NOCOUNT ON;
DECLARE @AureliusOutputTbl TABLE (ID INT);
INSERT INTO gigDocs (
docFile, docTitle, isPolicyDoc, isEndDoc, isQuote, isInvoice, policyTypeID, stateSpecific, insCompID, ifInclude)
OUTPUT INSERTED.docID INTO @AureliusOutputTbl
VALUES (
@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10);
SET NOCOUNT OFF;
SELECT ID From @AureliusOutputTbl;',N'Test_Dcoument.pdf',N'Test6',N'T',N'F',N'F',N'F',1,N'ALL',1,N'CYBER'
select @p1
@P3 - @P6 should all be "BIT" not nvarchar(1).
Entity column type is set to BOOLEAN...
[Column('isPolicyDoc', [])]
FisPolicyDoc: Nullable<Boolean>; //example
Why is Aurelius trying to use nvarchar instead of bit? Any suggestions to correct?
Note: This is through an XDataServer via TXdataWebDataset, posted here since I wasn't sure where this should go and appears to be Aurelis related.