Current limitations - BHoM/SQL_Toolkit GitHub Wiki
Push
- Objects can only be pushed to a single table.
- That table must already exists
- Only the properties of the object that can be found in the table will be pushed. Those properties must be of one of the supported type provided below
- CustomObjects are supported as long as the content of their CustomData matches the column of the SQL table and their properties are one of the supported types.
Pull
- Objects can only be pulled from a single table.
- Non-primitive properties that are stored in another table and stored as keys in the target table will not be pulled.
Supported types
Here's the list of C# types that are supported as columns of a table
| Object type | Supported? |
|---|---|
| bool | ✓ |
| int, float, double | ✓ |
| string | ✓ |
| Date | |
| Guid | |
| Enum | |
| Structure | |
| Object |