Write only to an external database in BC 15 OnPrem

borealis

I'm trying to write (insert) to two external tables from an on premise installation. We're essentially updating shipment label information for an external process to pick up the label data. I have no need to read or modify existing records in the table, although I will need to be able to delete based on a date/time filter.

I have old code for pre-BC that uses system.data.sqlclient .net controls and custom built strings to insert data, however I am unsure how best to proceed with a BC implementation. I noticed that I could use table objects with the type ExternalSQL, however that would consume two table objects on the client's license, and I'd prefer not to do that if I can.

Is there a way to execute direct SQL "Insert into" strings from BC?

kylehardin

You can use DotNet with BC OnPrem, but if you do so, you will never be able to take that solution to the cloud (SaaS). The cleaner SaaS-friendly way of doing this is with Odata, web services, or the API.

kylehardin

You can use DotNet with BC OnPrem, but if you do so, you will never be able to take that solution to the cloud (SaaS). The cleaner SaaS-friendly way of doing this is with Odata, web services, or the API.