i'm getting this weird error i've not seen before in Visual Studio.
I'm trying to call a stored procedure in MySql using Pomelo EntityFramework and in doing so I'm having to create a MySqlParameter.
This is the class that's creating the parameter:
using ITSystemAPI.DataAccess.DbContexts;
using ITSystemAPI.DataAccess.IRepositories;
using ITSystemAPI.DataAccess.IRepositories.MySqlStoredProc;
using ITSystemAPI.Domain.Target;
using System;
using System.Collections.Generic;
using System.Text;
using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;
using MySqlConnector;
namespace ITSystemAPI.DataAccess.Repositories.MySql.Tickets
{
public class ClientTicketInformationRepository : IAsyncTicketsByClientIdRepo
{
private readonly MySqlUnitOfWork _dbContext;
public ClientTicketInformationRepository(MySqlUnitOfWork dbContext)
{
_dbContext = dbContext;
}
public async Task<List<TicketInfoLocal>> GetTickets(Guid clientId)
{
var param = new MySqlParameter
{
ParameterName = "@clientId",
Value = clientId
};
var result = await _dbContext.ticket_info.FromSqlRaw(@"exec GetTicketInformation", param).ToListAsync();
return result;
}
}
}
And when it gets to the point of creating the Parameter, it gives me this error:
Now the weird this is when I F12 on the MySqlParameter, if goes to the .cs file it says it cannot find
Any help would be appreciated
You can stop Visual Studio from trying to load code from outside your project by going to Tools > Options > Debugging > General, and checking "Enable Just My Code".
Alternatively, the MySqlConnector package is built with Source Link, so it may also work to check "Enable Source Link support" instead.