radial gradient - multipule color css

                                                

 <h2 class="text-center" style="margin-top: 0; padding-top: 30px; padding-bottom: 30px; background: radial-gradient(farthest-side circle at 100px 35px, #f6d0ea, #d8f7f8 86%);">Azure SignalR Group Chat</h2>

    <div class="container" style="height: calc(100% - 110px);"><div>

background: radial-gradient(farthest-side circle at 100px 35px, #f6d0ea, #d8f7f8 86%);

CROSS APPLY and get inner json node details

 SELECT s.StudentId,

s.StudentName,

s.[Message],

[m].MessageType,

[m].[Subject],

[m].[MessageBody]

FROM Student s 

CROSS APPLY OPENJSON([Message], '$.Messages') sm

CROSS APPLY OPENJSON(sm.value)

WITH

(

MessageType NVARCHAR(50),

[Subject] NVARCHAR(50),

[MessageBody] NVARCHAR(50)

) AS [m]

--Insert into Student values(1,'TestStudent','{"Messages": [{"MessageType": "Email","Subject": "Payment","MessageBody":"Kindly pay your school bill amount {amount}"},{"MessageType": "Sms","Subject": "Payment","MessageBody":"Kindly pay your school bill amount {amount}"}]}')

How to get Xml Inner node value using c#

How to get Xml Inner node value using c#

<?xml version="1.0"?>

<Document xmlns="urn:hl7-org:v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sdtc="urn:hl7-org:sdtc">

   <docTime value="19981001064138-0400"/> 

</Document>

Name space: xmlns="urn:hl7-org:v3"

Node: DocTime

C# code:

XDocument doc = XDocument.Parse(xmlData);

var docTime = doc.Descendants(XName.Get("{urn:hl7-org:v3}docTime")).FirstOrDefault().FirstAttribute.Value;

result of docTime: 19981001064138-0400

Dynamic Linq query in Core

Dynamic Linq:

namespace System.Linq.Dynamic.Core

https://dynamic-linq.net/

Example in Fiddler:

https://dotnetfiddle.net/GdxsMG

var context = new EntityContext();

// Example 1: Strongly styped = normal LINQ

var example1 = context.Customers

.OrderBy(c => c.City).ThenBy(c => c.CompanyName)

.ToList();

FiddleHelper.WriteTable(example1);

// Example 2: Dynamic

var example2 = context.Customers

.OrderBy("City, CompanyName")

.ToList();

FiddleHelper.WriteTable(example2);

// Example 3: Dynamic

var example3 = context.Customers

.OrderBy("City").ThenBy("CompanyName desc")

.ToList();

FiddleHelper.WriteTable(example3);

// Example 4: Dynamic

var example4 = context.Customers

.OrderBy("City, CompanyName desc")

.ToList();

FiddleHelper.WriteTable(example4);