C#/.NET/EFcore Assistant-C# Code Optimization Aid

Example

Example Code: Configuring DbContext and models, performing migrations, and executing LINQ queries.

Scenario

A developer needs to set up a new ASP.NET Core project with a SQL Server database. The assistant provides guidance on creating the DbContext, defining entity models, and applying migrations to create the database schema.

Example

Example Code: Serializing and deserializing JSON objects using the JsonConvert class.

Scenario

A developer is working on an API that consumes and returns JSON data. The assistant helps in writing code to serialize data into JSON format and deserialize JSON responses into C# objects.

Example

Example Code: Parsing and manipulating XML data using the XDocument class.

Scenario

A developer needs to read configuration settings from an XML file and update certain values. The assistant provides code snippets to load the XML file, query elements, and save changes.

Example

Example Code: Using LINQ queries to filter, sort, and transform collections.

Scenario

A developer is processing a collection of customer records and needs to filter and sort the data based on specific criteria. The assistant offers examples of LINQ queries to achieve these tasks efficiently.

Example

Example Code: Demonstrating the use of 'using' statements for resource management and writing clear, maintainable code.

Scenario

A developer is writing a method that accesses a database and needs to ensure resources are properly disposed of. The assistant shows how to use 'using' statements to handle this, along with tips for writing readable code.