I want to Map as custom SQL which will return same fields wi

Question

I want to Map as custom SQL which will return same fields with tracking from Table as Follows

Entity :

public class Foo { public int Id{get;set;} public string Name{get;set;} }  Table Foo: Id int not Null, Name varchar(max)

cutom Sql :

Select Id , dbo.decript(Name) as Name from Foo

I am going to map Stored Procs for insert and update

Sujeet Suman · Answer

Vikrant please once use below code : - using (var context = new DataContext01()) { context.Foo.ExecuteSqlCommand( Write Query Here For INSERT & UPDATE ); } If this is helpful for you then please accept my Answer .