Setting up LINQPad Convert SQL to LINQ AI provider?
I'm looking for some help on setting up LINQPad AI feature (SQL to LINQ). My company has CoPilot so I'm assuming the "Add AI Provider" should be Azure OpenAI (classic)? Unfortunately, the recommended "OpenRouter" AI provider is blocked by my company.
When I select the Azure OpenAI (classic) option I get several options that I'm not sure how to complete:
Resource Name ... I assume any project name I'm using LINQPad for or is this a URL to the AI provider?
Deployment Name ... we're not doing any deployments with LINQPad so don't know what this is about?
API Key ... how/where do I get API Key from Azure OpenAI?
Models (choose one) ... where would I get information about the supported models from Azure OpenAI?
I would appreciate any help as the SQL to LINQ (if it works well) is going to be a HUGE time saver on some of my projects.
Comments
-
Unfortunately, Copilot doesn't allow you direct access to the models.
To make this work, you will need to set up an AI Foundry resource in Azure. This will then give you a model with an endpoint that you can consume in applications such as LINQPad.
