Microsoft.Data.SqlClient.SqlException: 'Could not find stored pro

Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List

Yogesh Kumar

Vote:

i have installed optimizely customized commerce v14 foundation code in visual studio 2022 from below github link and created database through below commands

https://github.com/episerver/Foundation

dotnet-episerver create-cms-database Foundation.csproj -S servername -U sa -P "sa"
dotnet-episerver create-commerce-database Foundation.csproj -S servername -U sa -P "sa"

when i run the solution locally on my machine i m getting below errors , dont know how to resolve this

error : Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List'.'

Please help

#304974

Jul 11, 2023 6:12

Avinash Pawar

Vote:

Hi Yogesh,

Even I was facing same issue.

Rather i tried like below. After running you can access the site at http://localhost:5000/en/ it works properly
Hope this helps to resolve the issue. Please accepts this as answer if solves your problem.

open command prompt as administrator
git clone https://github.com/episerver/Foundation.git
cd foundation
git checkout main
setup.cmd 
dotnet run --project .\src\Foundation\Foundation.csproj

#304978

Jul 11, 2023 8:25