Learning to connect a visual Basic Plugin with SQL Server

[Anonymous]

I am trying to learn coding with VB.net for creating AutoCAD plugin.

In this regard, I found many useful tutorials that helped me to start, but I want to go to the next level and connect my plugin with a SQL database to save and retrieve data from it.

I couldn't find any useful tutorial in the Internet so I really appreciate if you can help me to find a learning path.

Best regards

[norman.yuan]

You should search .NET ADO for Microsoft .NET Framework. There are tons of code samples, tutorials available on line, and a lot of YouTube tutorials. Here are a few of them:

https://www.codeproject.com/Articles/8477/Using-ADO-NET-for-beginners

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-code-examples

https://msdn.microsoft.com/en-us/library/jj943772.aspx

https://www.youtube.com/watch?v=aoFDyt8oG0k&list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7

Note that these samples/tutorial mostly run with stand-alone EXE apps. But they can be exchangeably used in AutoCAD plug-ins.

With today's technologies, it becomes less and less that an desktop application (or AutoCAD) directly connects to a database server (SqlServer); instead, more and more connect to services either hosted in the private intranet, or hosted in the cloud, and the services often wraps up the access to various databases on behalf of client-side application. But as beginner, it is OK to start with accessing database server directly, and move on to learn how to connect to services.

Also, to learn to access database server with ADO.NET, you probably also need to know/learn how to setup SqlServer (or its free version SqlServer Express) and set up database/security...

[Anonymous]

Thank you so much. I think the way is clear to me now.