I would like to import a SQL Database into my site using C# code?
If you have simple tables, then you can export SQL table in excel. You can then actually create a new list with the import as spreadsheet option in SharePoint. Otherwise, write a powershell open sql connection and insert into SharePoint code effort but useful if you have complex data tables.