Short Coding Snippet

 select RequestNo,FileName,PaymentStatus,count(0) as TxnCount,SUM(PaidAmount) as Amount ,SUM(SUM(PaidAmount)) over(Order by RequestNo) as RunningSum from Tbl_T_CommunityPaymentOnline where  IsDeleted is null and RequestNo>=131 and PaymentStatus='Inprocess' group by RequestNo,PaymentStatus,FileName

Create C# Model Using Query Postgre SQL Query : SELECT 'public',  CASE WHEN data_type='bigint' THEN 'int64' WHEN data_type='integer' THEN 'int' ELSE 'string' END ,column_name,'{get;set;}',data_type   FROM information_schema.columns  WHERE table_schema = 'public' AND table_name   = 'Tbl_M_RegistrationLand' Output : public class RegistrationLand {     public int LandRegsitrationID { get; set; }       public int KhataNumber { get; set; }     public string? owner { get; set; }     public string? khata_type { get; set; } } Generate Using View :  SELECT 'public ', CASE WHEN format_type(atttypid, atttypmod)='bigint' THEN 'Int64' WHEN format_type(atttypid, atttypmod)='integer' THEN 'int' ELSE 'string' END , attname AS column_name ,'{get;set;}' FROM   pg_attribute WHERE  attrelid = 'public.vw_applicationDetails'::regclass ORDER  BY attnum;