In one of my recent projects I needed to generate a datatable in C# whose fields could vary depending on which properties of a variable needed to be exported from the system. It needed to be able to generate the SQL CREATE TABLE script on the fly and create the table in the database, and then populate the table with the data to export, either using a SqlBulkCopy object or on a row-by-row basis. The tutorial below provides a good code base to developing this kind of functionality, as well as providing a link to a similar project on MSDN....
Continue reading...
Ben Foster
Full Stack Software Engineer harbouring in Leeds, UK. Passionate about all things tech and people.
Latest Posts
- Using an AI Agent with AWS Bedrock to control my smart heating
- Connecting services with ECS Service Connect
- Managing dependencies between apps when using AWS ECS Service Connect
- Challenges working with and tuning AWS Amplify and AppSync with Flutter
- Cross-platform mobile app prototyping with Flutter and AWS Amplify