Entity Framework 6.0

0 answers

Bilgisayarıma .net 7.0 kurdum fakat powershell üzerinden dotnet tool install --global dotnet-ef komutu kullandığım zaman kurulu değil hatası alıyorum yardımcı olur musunuz

Visual Studio 2019 kullanıyorum ancak bu kurulumu yapamadım yardımcı olursanız sevinirim

asked

Muhammed Mustafa 0

commented

Jack J Jun 19,036 Microsoft Employee

4 answers

Porting Entity Framework 6 to Entity Framework Core

I am porting an application from ASP.net MVC 5 to ASP.net Core MVC and I reach out in the area pointing the Entity Framework related modules. I have the generated classes and I also have the edmx and tt files, I added the files to a newly created Class…

asked

cebuhax0r 21

answered

Karen Payne MVP 29,131 Microsoft MVP

0 answers

New optional Foreign Key triggers Exception when querying

Hello there! I ran into an issue that I don't understand, therefore here I am. Here is my model: public class Property : FullAuditedEntity<Guid>, IMayHaveTenant { public int? TenantId { get; set; } …

asked

Julien CHEVREAU 1

commented

Jack J Jun 19,036 Microsoft Employee

1 answer

Ado.Net Entity Data Model does not appear on item page in Visual Studio 2022 Asp MVC Project

Ado.Net Entity Data Model does not appear on item page in Visual Studio 2022 Asp MVC Project FrameWork= .:Net 7.0 Please help. Thanks not as below

asked

umutins umut 20

accepted

umutins umut 20

3 answers

Build Update Query CommandText in foreach loop for bulksave to DB

Build Update Query CommandText in foreach loop for bulksave to DB foreach (var item in items) { item.Locked = IsLocked; …

asked

IDGO 426

commented

IDGO 426

2 answers

c# Performance Issue while saving to DB

foreach (DictionaryEntry ID in IDs) { int qWorkID = int.Parse(ID.Value.ToString()); int SplitID = Convert.ToInt32(ID.Key.ToString()); var INSP = (from insp in Model.InstallSplitSet …

asked

IDGO 426

commented

IDGO 426

5 answers

Linq query causing performance Issue

foreach (DictionaryEntry ID in IDs) { int qWorkID = int.Parse(ID.Value.ToString()); var QWF = (from qwf in Model.QWorkflowSet where qwf.QWorkID == qWorkID select qwf).FirstOrDefault(); …

asked

IDGO 426

commented

IDGO 426

1 answer

How to get sub level data using ef core?

here is my table: public class Depart { public int Id{get;set;} public int TopDepartId{get;set;}// top level depart id public int DepartName{get;set;} } I want to get depart's all sub departs if there is depart{Id=1} and…

asked

打玻璃 1,446

commented

Lei Zhang-MSFT 6 Microsoft Employee

2 answers

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…

asked

Larry Axon 1

commented

Jack J Jun 19,036 Microsoft Employee

0 answers

Inheritance Table-per-type can't finde method UseTptMappingStrategy()

Ef core version 7.0.1 as mentioned in the documentation there is two way to implement tbt https://learn.microsoft.com/en-us/ef/core/modeling/inheritance#table-per-type-configuration and that is what I did that works fine but if…

asked

Kareem Azam 1

commented

Lei Zhang-MSFT 6 Microsoft Employee

2 answers

Database design suggestion

Hi there, I have an ASP.NET web API application and am trying to upgrade it to Core. I am using EF 6, code first. I have this entity but the requirements changed. Now I have more than one price and currency for a product. How can I design the…

asked

Cenk 666

commented

Bruce (SqlWork.com) 27,936

0 answers

Possible Bug in Entity Framework

Link of bug description... CREATE TABLE IF NOT EXISTS users ( UserId int auto_increment, RegisterId int, PRIMARY KEY(UserId) ); CREATE TABLE IF NOT EXISTS products ( ProductId int auto_increment, ProductName…

asked

cinfis 1

commented

Lei Zhang-MSFT 6 Microsoft Employee

1 answer

DbGeometry instances created with wrong SRID

The method below is supposed to create an instance of DbGeometry that reflects the input SqlGeometry. My application and the data behind it work solely with SRID 102605 (this is a custom projection), but all of the static creational methods on the…

asked

Dan Narsavage 1

answered

Dan Narsavage 1

0 answers

Slowness in entityframework query

Hi I am facing slowness issue when retrieve data via entityframework 6. It query a table, with return 20 records only. The SQL statement is fast, completed within sec However, when I use EF code as below, it takes 11-15 secs. public class…

asked

Chan Kok Kiet 1

commented

Jack J Jun 19,036 Microsoft Employee

1 answer

Update changes using Repository pattern with no Update command

Hoping someone could get me back on track here. Im going through a tutorial to introduce the Repository pattern with Entity Framework 6. So far its all been working in my project. One of the comments made by the author is there is no need to have an…

asked

Mr Edge 121

commented

Buddhika 1

2 answers

Framework rules and guideliness

Hi all what are the rules and Guideliness for .NET framework we should follow for creating the application

asked

Siddangoud Bharamagoudar 21

commented

Jiachen Li-MSFT 10,831 Microsoft Employee

1 answer

Microsoft dotnet ef migration error

When I run any dotnet ef command, like "dotnet ef migrations add InitialCreate", i get the following error message: Could not execute because the specified command or file was not found. Possible reasons for this include: * You misspelled a…

asked

Kefiloe Moshoaliba 1

answered

Michael Taylor 37,441

0 answers

UserManager.RemoveFromRolesAsync and UserManager.IsInRoleAsyn return user not in role

I have a small project generated using vscode and dot net 7 core focused on Identity operations. -- dotnet core project under parallels windows 11 on an M1 max macbook -- Docker container running azure edge with a database simply for testing…

asked

York Bush 1

commented

Rena Ni - MSFT 1,526 Microsoft Employee

3 answers

Configure OnModelCreating function in context file

I have one patient table and one appointment table. In appointment table i am keeping Patient id. Here my question is how configure in OnModelCreating function in context file. My requirement is if i pass one date i want to list all patient have…

asked

Binumon George 161

answered

Arun Siripuram 586

0 answers

ORA-12704: character set mismatch with update statement

I'm using Oracle.ManagedDataAccess.Client to make queries to oracle database, but having an issue in update query. I tried different workarounds like CAST with NVARCHAR2 and wrote DBInterceptor by following this POST. But none of them are…

asked

Saud Khan 26

commented

Ken Tucker 5,796

Filter

Content

216 questions with Entity Framework 6.0 tags

Bilgisayarıma .net 7.0 kurdum fakat powershell üzerinden dotnet tool install --global dotnet-ef komutu kullandığım zaman kurulu değil hatası alıyorum yardımcı olur musunuz

Porting Entity Framework 6 to Entity Framework Core

New optional Foreign Key triggers Exception when querying

Ado.Net Entity Data Model does not appear on item page in Visual Studio 2022 Asp MVC Project

Build Update Query CommandText in foreach loop for bulksave to DB

c# Performance Issue while saving to DB

Linq query causing performance Issue

How to get sub level data using ef core?

VS 2022 Windows 11 ARM64 EF Diagram failes missing GraphObject DLL

Inheritance Table-per-type can't finde method UseTptMappingStrategy()

Database design suggestion

Possible Bug in Entity Framework

DbGeometry instances created with wrong SRID

Slowness in entityframework query

Update changes using Repository pattern with no Update command

Framework rules and guideliness

Microsoft dotnet ef migration error

UserManager.RemoveFromRolesAsync and UserManager.IsInRoleAsyn return user not in role

Configure OnModelCreating function in context file

ORA-12704: character set mismatch with update statement