Programming AutoCAD with SQL Server Database using C#

Programming AutoCAD .NET API with SQL Server Database integration using C#. You will perform database CRUD operations

This course will walk you through programming AutoCAD .NET API with SQL Server Database integration using C#. This is a hands-on course with lots of coding to teach you how to perform basic database operations like Create, Read, Update, and Delete (CRUD). You will learn how to extract AutoCAD objects’ properties and load them into SQL Server database.

What you’ll learn

  • Learn to connect AutoCAD to SQL Server Database using C#.
  • Learn how to extract AutoCAD Objects and store in SQL Server Database.
  • Learn how to perform CRUD (Create, Retrieve, Update, Delete) Operations using C#.

Course Content

  • Introduction –> 2 lectures • 4min.
  • Section 2 – Tools and SQL Queries –> 9 lectures • 47min.
  • Section 3 – Create Database and Tables –> 7 lectures • 27min.
  • Section 4 – Loading into SQL Server Database –> 20 lectures • 1hr 47min.
  • Section 5 – Retrieving Data from Database –> 19 lectures • 2hr 11min.
  • Section 6 – Updating Data in SQL Server Database – Overview –> 21 lectures • 1hr 49min.
  • Section 7 – Deleting Data in SQL Server Database from AutoCAD – Overview –> 22 lectures • 51min.

Programming AutoCAD with SQL Server Database using C#

Requirements

  • Basic knowledge of AutoCAD Programming using C#.
  • Basic knowledge of SQL Server Database.

This course will walk you through programming AutoCAD .NET API with SQL Server Database integration using C#. This is a hands-on course with lots of coding to teach you how to perform basic database operations like Create, Read, Update, and Delete (CRUD). You will learn how to extract AutoCAD objects’ properties and load them into SQL Server database.

You will learn the following:

– Learn AutoCAD .NET API Programming using C#

– Learn how to use Windows Forms for your User Interface

– Learn how to use XDATA to attach to and read from the object

– Learn how to connect to SQL Server database using ActiveX Data Object (ADO)

– Learn to perform Create, Read, Update and Delete (CRUD) using SQL Server Database

– Learn how to use SQL Server Management Studio

– Learn how to extract Line Object’s Properties and store/retrieve into/from SQL Server Database

– Learn how to extract MText Object’s Properties and store/retrieve into/from SQL Server Database

– Learn how to extract LWPolyline Object’s Properties and store/retrieve into/from SQL Server Database

– Learn how to extract Blocks (with/without attributes) Object’s Properties and store/retrieve into/from SQL Server Database

After taking this course, you will have a strong knowledge working with AutoCAD and SQL Server Database by storing your data persistently that you can use for other Applications.