Grid Elements database service for managing and querying Grid Elements database
- Element
- Bay
- Bus
- BusReactor
- FilterBank
- GeneratingUnit
- HvdcLine
- HvdcPole
- Line
- LineReactor
- SubFilterBank
- Transformer
- SVC
- FSC
- Compensator
- ElementOwner
- Fuel
- GeneratingStation
- GeneratingStationClassification
- GeneratingStationType
- Location
- Owner
- Region
- State
- Substation
- SubstationOwner
- VoltageLevel
- Buses
- Lines
- Locations
- Owners
- Regions
- States
- Substations
- VoltageLevels
Refer WRLDC Tables excel file for CRUD logic strategies
- Bay - Started CRUD in App layer
- Bus Reactor
- Transformer
- Generating Unit
- LineReactor
- HvdcLine
- HvdcPole
- Filter Bank
- SubFilterBank
- restict substations changes in lines when there are connected elements like line reactors
- Define control area and attach it to element
- Model MSC, MSR, TCSC, STATCOM instead of compensator
- Model SVC, FSC
- whitelisted characters in names implementation during create and update commands
- lat long value object implementation
- lat long to be made optional
- Clean architecture - https://github.com/jasontaylordev/CleanArchitecture/blob/a713468e27deb655eeb96b340318274eeccc5c3f/src/Infrastructure/Data/ApplicationDbContext.cs
- Many-to-Many in EF Core - https://learn.microsoft.com/en-us/ef/core/modeling/relationships/many-to-many#direct-use-of-join-table
- Transactions in EF Core - https://learn.microsoft.com/en-us/ef/core/saving/transactions
- multi select reference - https://github.com/nagasudhirpulla/wrldc_scada_issues_portal/blob/master/src/WrldcScadaIssuesPortal/ScadaIssuesPortal.Web/Views/ReportingCases/Create.cshtml
- Using database transaction in mediatr command pipeline - https://github.com/Jefferycheng/FlexibleTransactionHandler/blob/master/FlexibleTransactionHandler.WebApi/Application/Behaviors/TransactionBehavior.cs
- Smart Enum model binding - https://github.com/nagasudhirpulla/SmartEnumModelBinding/tree/main