วีดีโอ

Hey, thank you - are you referring to the video that shows you how to chat with a database? th-cam.com/video/hw6oTjw9_Ro/w-d-xo.html

Thank you!

Thank you for the reminder, I remembered right after I published it 😆

Thanks for letting me know!

I believe current gpt models are limited to 128k tokens - I would recommend either breaking apart your schema to only the tables you need if possible, or searching for an AI model with higher token limits. There might also be local or self hosted models for code generation that support higher token inputs. I have some other videos about local ai models that show this database connection scenario

​@@alexthecodewolf​ Thank you sir

I don't have this video yet, but I'm planning to make one!

@@alexthecodewolf Thanks. Can you please give me some pointers on how to do it? All the chatbots deals with indexer and cognitive services.

Hey, I probably should have mentioned you have to apply for openai access, but it's fairly easy to get approved. If you can't get access you can also substitute the AI service with gpt-4 similar alternatives like standard openai instead of azure openai, or even local ai models that are specifically trained for code generation

Yep, local ai models support function calling.

@@alexthecodewolf Thanks, Can you showcase something or share any code article.

@@Ajmal_Yazdani You can find some examples in the semantic kernel docs at learn.microsoft.com/en-us/semantic-kernel/agents/plugins/using-the-kernelfunction-decorator?tabs=Csharp I would recommend using semantic kernel for local AI dev. Semantic kernel and more involved AI flows with local functions, plugins, services etc is a topic I plan on covering here in the near future. Semantic kernel is a big topic so I'm working on the best way to present tthat.

Thanks for the feedback and view!

Hey, thanks for the comment, there's already complete blazor courses on pluralsight by another author so I wouldn't be eligible to do that. I have thought about making one on TH-cam here of some sort but full courses are very time consuming and already exist on here as well, maybe at some point

@alexthecodewolf Yeah. But you don't get to learn all of it. Learning bit by bit on different TH-cam channels is difficult. Also, bootcams are way out of budget. I am from India, and platforms like Pluralsight help us with the volume of courses and also our pockets. I think this dilema will always remain. Thank you for your reply.

@@JtendraShahani Hey, you are correct that this is an ongoing challenge. As a self taught developer, I can relate. Many of the videos on this channel are oriented towards learners who already know the basics but are looking for guidance around new or specific topics so they don't have to watch additional courses, they can just supplement their knowledge on specific topics in shorter form content. However, I would like to get to the point where I have the time or incentives to create full courses on TH-cam. Thanks for sharing your thoughts on this!

Hey, yes it can work with local DB and on prem. You would just replace the connection string placeholders in the demo app with localdb connection strings. You could then use the same Azure AI service or you could use a local AI model - I just posted a couple videos explaining how to setup and connect to local AI if that's what you're looking for.

Also, I want to add that this is great content. Useful real-world examples like this will be golden as more people leverage AI in the enterprise landscape.

Thanks for the feedback! I'm not sure if I understand your original question though - are you asking about essentially just giving the AI a connection string or something so it can access the database directly?

Yes, exactly that. ​@@alexthecodewolf

@@justinkrawczak4929 As far as I know it's not possible to just give an AI a connection string and have it understand/explore a database. I think the closest solution I've seen to this is to add some kind of layer between the AI and the database, such as using a RAG solution where you connect the AI to a search service that has crawled your database, or using vector search capabilities to provide the AI with database data. I have a couple videos on my channel that explore these types of topics, but I don't know of any "Direct access" solutions.

Thank you, that really means a lot. Really trying to grow this channel into something big and deliver content that simplifies convoluted topics.

Hey, thanks for watching and providing feedback. This tutorial made some assumptions about coding knowledge with .NET or other languages, but I probably should have mentioned that up front. If you want to get started with .NET to recreate the code sample you can download visual studio here, which is the code editor I'm using that also installs .NET for you: visualstudio.microsoft.com/ You can then either clone the sample app from GitHub and just open it up in Visual Studio and follow along with the tutorial, or you can create a new project using Visual Studio and copy in the code. File -> New Project -> C# console app. Hope this helps a little bit!

I actually just made a video about this using Ollama, hah. It shows this same setup at the end using codellama th-cam.com/video/177qX6mpyMg/w-d-xo.html The concepts in this video should work with any model that is skilled at text to code (such as code llama) and a SQL database of some sort. You'll have to experiment with different models and prompts to see which works best.

Hey, this should work using any powerful large language model and SQL based database, did you have a specific scenario in mind?

Thanks for this specific feedback - this is actually why I made the video. There was actually a good amount of .NET content at Build but it was sort of overshadowed by all of the AI, Azure, and tooling integration (copilots/analytics) news.

So much betting on half baked AI also disheartening. Pre-emptive laying off of devs without any real AI results I'm positive are hurting.

I don't think so, because App Service is designed to rely on some sort of "authority" to verify the user. You'd probably have to roll your own solution for this, such as ASP.NET Core's new identity system.

Story of my life lol