Question

Select Class Cast Function

06:34 Oct 26, 2020

The Cast function in select class is not working, second parameter 'DBDataValueType' gets error as 'Error CS1503 Argument 2: cannot convert from 'System.Guid' to 'Terrasoft.Core.DBDataValueType' Terrasoft.Configuration.Dev'.

var SelQuery = new Select(UserConnection)
.Column(Func.Cast("UsrName", DBDataValueType.TextDataValueTypeUId)).As("UsrName")
.From("UsrTableName") as Select;
 
var SelRecord = SelQuery.ExecuteScalar<string>();

2 comments

Anastasiia Markina

19:52 Oct 28, 2020

Hi there,

It seems that the error may be hidden in this line:

.Column(Func.Cast("UsrName", DBDataValueType.TextDataValueTypeUId))

Please try to use the code below as an example:

var textDataValueType = new TextDataValueType(new DataValueTypeManager()) {
   Name = "Text"
};
var SelQuery = new Select(UserConnection)
   .Column(Func.Cast("Name", textDataValueType)).As("Name")
   .From("Contact") as Select;
var SelRecord = SelQuery.ExecuteScalar&lt;string&gt;();

Regards,

Anastasiia

Kumaran K

08:10 Oct 29, 2020

Anastasiia Markina,

Thanks for code, Now its working.

Show all comments