Transform SQL String to Entity Framework

Question

I have a SQL statement in C# in a string variable:

string sqlString = "UPDATE \"MyTable\""
                   + $" SET \"STATUS\" = {(int)StatusValue.Confirmed}"
                   + $" WHERE \"ID\" = {MessageId}";

But now I need to transform it to Entity Framework, but unfortunately I do not know Entity Framework well enough. How do I do that?

Shafiqul Bari Sadman · Accepted Answer · 2022-08-22 10:54:08Z

1

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

it would be like

 using (var db = new YourContextDB())
 {
  var result = db.TableName.SingleOrDefault(b => b.ColumnName == 
  parameter);
  if (result != null)
  {
    result.UpdatebleColumnName = "Some new value";
    db.SaveChanges();
  }
 }

check https://learn.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

edited Aug 22, 2022 at 10:54

answered Aug 22, 2022 at 10:44

Shafiqul Bari Sadman

2561 gold badge3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jodrell Over a year ago

You could use the actual column names, making some assumptions about the model.

Shafiqul Bari Sadman Over a year ago

yes, i could . But answered like this for his better understanding.

Iavor Orlyov · Accepted Answer · 2022-08-22 11:52:30Z

0

You don't need this string anymore. All you need is an instance of your DatabaseContext.

Your code would be similar to this one:

using var dbContext = new YourDbContext();
var message = dbContext.MyTable.FirstOrDefault(mt => mt.Id == MessageId);
message.Status = (int)StatusValue.Confirmed;
dbContext.SaveChanges();

answered Aug 22, 2022 at 11:52

Iavor Orlyov

5621 gold badge4 silver badges17 bronze badges

Collectives™ on Stack Overflow

Transform SQL String to Entity Framework

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related