Description
Many AutoCAD software add-ins are limited in their reach to the computer on which they were installed. When a need arises to reach out and tap enterprise resources such as Microsoft SQL Server data, a few strategic lines of code is all that’s needed to pull that data in from SQL Server or push data out to SQL Server. Learning those few lines of code is a good start, but we can do so much more if we take more than 10 minutes. So we’ll use every minute of this class to do so much more. Stored Procedures—perhaps you've heard of them but haven't used them. Scalar Functions—they can be good and they can be bad. Views? Indexes? They can all be yours if you attend this 90-minute instructional demonstration.
Key Learnings
- Learn how to incorporate SQL Server into your .NET add-ins
- Learn how to link AutoCAD entities to SQL server records
- Learn how to improve performance using Stored Procedures, Scalar Functions, Views, and Indexes
- Learn how to benchmark to determine where to fine-tune SQL Server