Content
PMC EF commands error: Unrecognized command or argument 'C#'
In Visual Studio's Package Manager Console (V 6.6.0.61), the command get-migrations, and other Entity Framework commands, output: Specify --help for a list of available options and commands. Unrecognized command or argument 'C#' I have successfully run…
GraphQL API - Fetch data from more than one table
Hi, I want to write an .net core graph ql api(using hot chocolate), which will return the data from db(one or more tables). They are independant tables. Say I want to retrieve data from employees, and offices. There is no relationship between these 2…
.net program poor performance on windows 2019 server
Hello, We have a problem with a small program running well on a Windows 2012R2 but not on a Windows 2019. We did a small program for test just connecting to a sql database with entity framework 6.4.4 and making a count(*) on a table. It takes 3s on…
Using ADO.NET Entity Framework with MySql Data Provider
I'm going to start an ASP.NET Web Application project that uses the MySql database. I also need to create an ADO.NET Entity Data Model. I know I need to install "MySql for Visual Studio Tool" and "MySql Connector/NET". I have…
How to convert SQL query values separated comma to list by using entity framework core 7?
I work on asp.net core razor page . I face issue How to convert complicated sql query to entity framework core 7 Exactly I need to convert this SQL statement to LINQ to entity without write SQL statement on csharp meaning i need to use code first entity…
How To create a framework
How to create the framework in C# with Example
What's the best (and simplest way) to MOVE an SQL Server database file?
WHAT I HAVE: Visual Basic 2019, WinForms, .NET Framework 4.0+, Entity Framework 6.0+, SQL Server MY ISSUE: I'm writing a desktop app that uses Entity Framework to manage multiple databases (with user-specified catalog-name/mdf-file-name combinations)…
Replace AzureSQL db with Synapse Datawarehouse with Partitioning/Sharding technique - Possibilities?
Hi, We have SAAS applications that uses Azure SQL as datastore and connects using EntityFramework. We are exploring Synapse datawarehouse to replace AzureSql. We have below questions that need some assistance. Can we able to connect to datawarehouse…
Server Error in '/' Application Error.
Hi There; I have an ASP.NET MVC Application. Its version is .NET 4.5.2. It is facilitating Entity Framework and it is using Oracle Database 19c. I have found a bug in the application and I solve it. It runs smoothly on my local computer. Whenever I…
VS 2022 Windows 11 ARM64 EF Diagram failes missing GraphObject DLL
I updated my machine to a MAC Studio M1 and am running parallels with Windows 11 ARM. I am using Visual Studio 2022. On the new machine everything works BUT in the DAO/EF class the EDMX won't load the diagram. Error says…
resource cannot be found issue
I have an entity framework app I am rehabilitating. all the routes work just the one labeled details fails with the error below. Server Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are…
EF 6.0 - may cause cycles or multiple cascade paths.
For a couple of days, I'm having this issue and I have no idea how to fix it. I have User and UserDetail models, from which I'm trying to set PK & FK. About the application, its Web Api on .Net 6.0 public class User { [Key] …
MVC Entity Framework Random SQL Queries that don't map to db objects and may return multiple datasets.
ASP.NET (NOT CORE) MVC I'm storing a list of random queries in a table. NONE of the queries match any database object, like Customers, Orders, etc. Some queries may return more than one dataset. Some may be update or delete queries I need to…
Insufficient memory to continue the execution of the program for C# WPF
Project: I had Accounting project made in MS Access ADP 2003 project that connects to SQL Server database , Because it is not possible to create a beautiful and modern user interface with animation in Access, I decided to rewrite my program, I want to…
When Microsoft will release Entity Framework 6.x (.NET Full framework) having Microsoft.Data.SQLClient support?
We are migrating our .NET Full framework 4.8 based Data Access Layer projects from System.Data.SQLClient to Micosoft.Data.SQLClient. While it is very straightforward for AD0.NET based projects, we do have some projects where we are also using EF 6.0. As…
System.NullReferenceException message in creating Entity Data Model in an MVC project
Hi everyone, I created a localdb sql server file(School.mdf) in the App_Data folder in an MVC project using .Net Framework 4.8. I then added a table(Student) with only two attributes for testing. I tried to add new ADO .Net Entity Data Model into the…
VB.NET Entity Framework Using multiple databases
I'm trying to setup Entity Framework 6 in my VB.Net desktop application. I can get it working fine using Production database, but, this is a program where you can login to either production or the test database. When I created the model, I set it up to…
EF core 6 then Include issue
In EF core 3.1 I am able to include a collection of object using include statement. After that then include is not working in EF core 6 eg public class Parent { public int Id { get; set; } public string Name { get; set; } public…
Write Sql stored procedure with EF code first approach?
Hello. I am new with EF6 and I'm doing some tests with the ASP.NET MVC 5 and Code First. As a beginner, I’m confused. If I create model classes and then have the database (sqlserver) created by EF, can I then write stored procedures in the sqlserver…
Why Default Value of DataGridComboBoxColumn does not appear in the DataGrid in C# WPF?
Project subject: I had an MS Access 2003 adp VBA project that would connect to SQL Server Database, Now I'm converting that project to C# WPF, and I'm going to save data directly into SQL Server database from DataGrid in C# WPF Detail: I have DataGrid…