.NET - Is it possible to write a DataTable directly to a SQL Database?

Question

I'd like to do something like the following:

Dim Conn as new SqlConnection(ConnectionString)

MyDataTable.WriteToDB(Conn, "New Table")

Are there any shortcuts like this built into .NET?

Thanks

Answer 1

You probably want to start with the SqlDataAdapter class. It was pretty much designed to do exactly this.