I see folders for different languages that contain dll. Since this application is only in English language, do I need to copy all these folders for different languages to server?
The following SO post explains how to configure the web application to exclude localized assemblies.
.net core build produces localization folders
Resources in .NET apps
I was hoping the EF Core will create table on production server but it didn't. I see a folder called EFSQLScripts which contains a SQL script. How do I run this SQL script and where (on development machine or production server)?
Hoping is not a good approach. It sounds like you want to run pending migrations when that application starts?
ASP.NET Core - Automatic EF Core Migrations to SQL Database on Startup
Applying Migrations