Видео

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 ruclips.net/video/177qX6mpyMg/видео.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

I try, thank you, hah :D

This can be tricky - I'd recommend this solution for small to medium size databases, I have some other content coming for larger database solutions. However, theoretically this solution can also work with large databases if the table structure is consistent/standardized. You'd probably need to use one of the large GPT models though, such as the 32k GPT-4, which accept higher volumes of tokens. I've been trying to figure out if there's a way to have the AI Model "store" or remember the initial schema prompt, but I haven't been able to find an ideal solution for that.

@@alexthecodewolf Thanks a lot! Please, if you find some ways to have the AI model "store" or remember the initial schema, make such a video or write to me. I'm looking forward to it. Thank you!😀

Thank you, that means a lot!

Is it possible to run this on my mac m3? How can I get it up on my localhost once I have the Azure DB and the Azure OpenAI service up?

Awesome. Thanks

Thanks, did you get chance to get repo?

Thank you Alex, looking forward to learn how to do it

@@mukshobhit It's available now, thanks.

It's available now, thanks.

@@alexthecodewolf Thank you Alex, grateful for making it available

Hey, thanks for watching. There are definitely local AI models, but I haven't worked with them enough to recommend any sort of solution for this. Would probably be a good topic to research for another video :)

The last time I checked you had to apply via the form still, but I believe personal accounts can also get approved pretty quick - mine was.

Hey, thanks for watching. The syntax for the rendermode feature should match what you see here, as another reference: learn.microsoft.com/en-us/aspnet/core/blazor/components/render-modes?view=aspnetcore-8.0#client-side-rendering-csr If that's not working, are you on the latest .NET 8.0? You shouldn't have to include any usings for this to work, it should work by default.

@@alexthecodewolf Thank you for the repo and video. The 2 errors I am seeing show up when building your repo without any modifications on my part. The syntax of the rendermode directive in your repo is as shown in the link you provided. If I may ask, does the repo still build when you try it? The 2nd build error I'm getting is "Metadate file '...\FileUpload.Client.dll' could not be found.

You could save the file to any directory that the process running the app has access to, whether that's local or a web server

Thank you so much, generous!

Glad it was helpful!

When you say "non Azure client" - I assume you mean an app or service hosted on-prem or in another cloud, correct? This scenario should be supported, though I haven't tested it myself. The OpenAIClient in your code does accept both DefaultAzureCredential or ClientSecretCredential as a parameter. DefaultAzureCredentialshould be able to read IDs out of your appsettings file by default, or you could pass them in more directly to the ClientSecretCredential (I think this is the right one offhand but it might be a different credential type in the Azure.Identity library). You'd just have to create an app registration in azure and then provide your ids to to the OpenAIClient. Hope this helps!

Glad it was helpful!

That's a fair point, the prompt could be adjusted in various ways to try and capture the original style more. I don't have a ton of pokemon experience so I just enjoyed the cool CGI look.

Thank you!

Building a game with AI would be a good video topic :D

Awesome, thank you!

Great, thanks for the feedback!