Category Archives: ASP .Net

External assemblies

External assemblies Should be packaged in own .wsp in some situations. Package Designer > Advanced Tab


When to use Business Connectivity Services and when to use ADO.Net …

Use Business Connectivity Services (BCS) when you want to: 1. Provide a no-code solution 2. Create several Web Parts that would all use the same ADO to connect to the SQL database. 3. Re-use code even if someone renames the SQL server, moves the database, or renames a table or column. 4. Maintain one connection […]


SSIS and moving Excel files around

Need to upload an Excel to a SQL Server┬ádatabase on a regular basis? Check out the following article on SQL Server Integration Services (SSIS): http://www.excel-sql-server.com/excel-import-to-sql-server-using-ssis.htm