c# - Linq Query using Case statement and concatenate special character -

I am trying to change the SQL query below in the linq query but am unable to do this if you have another table If you can join and insert a special character such as '*', then how can you help with the type of case statement? Please help me how to do this.

  Choose specific amid, title + case when d. If Maid is not zero, then ending in the form of '*' Other '' title, Magitile FROM [MasterTitles] A left outer insertion title D Description A. [MyID] = D. [MyID] WHERE [PropertyID] is not empty [Title]  

Is there a better option? I have tried, but I am not able to know how to do this kind of LINQ query.

Try this like:

  var result = DatabaseMasterTitles. Where (M => m.PropertyID! = Null). Add (database.titly description, m => m.myid, t = & gt; tmid, (m, t) => new {MyID = m.myid, title = m.Title + (t.myid == empty? "": "*"), Magitile = M. Metatile}). OrderBe (M = & gt; M. ttl). Undoubtedly ();