1
 Follower
3
 Likes

Auto-create Output Entities / Structures for Custom SQL Statements

Aggregates & Queries
New

since you know which tables and fields are coming back for the SQL statement, you can automatically create the output structure for the SQL statement. If you don't know the type of data in a field, make it a TEXT type. But if I do something like this:

select {Car}.[Id] as CarId, {Owner}.[Id] as OwnerId from

{Car} inner join {Owner} on {Car}.[OwnerId] = {Owner}.[Id]


You know the structure will be like this:

CarOwner{

CarId: CarIdentifier,

OwnerId: OwnerIdentifier

}


OS doesn't need to make me manually create that structure and add it to the SQL Statement. This will save SOOO much time.

Created on 5 Jul
Comments (2)

Changed the category to Aggregates & Queries


views
61
Followers
1