Entity-Framework-DBZ

kevin/Entity-Framework-DBZ

Fork 0

024f9da8f9 Update README. master Kevin Matsubara 2025-04-14 22:33:11 +02:00
2d14366feb Add retry option for SQL server example. Kevin Matsubara 2025-04-14 22:33:02 +02:00
b32e390c5c Add SQLite timeout option. Kevin Matsubara 2025-04-14 22:32:32 +02:00
30d69e9f79 Create query filter for soft delete on League and add an example function. Kevin Matsubara 2025-04-14 22:24:46 +02:00
02d8477b05 Create migration for League soft delete flag. Kevin Matsubara 2025-04-14 22:14:12 +02:00
bcb084d733 Add soft delete flag to League model. Kevin Matsubara 2025-04-14 22:13:48 +02:00
f02538b281 Create migrations for concurrency tokens. Kevin Matsubara 2025-04-14 22:11:01 +02:00
2a09ddb0da Add concurrency checks. Kevin Matsubara 2025-04-14 22:10:45 +02:00
f6d5733992 Add example with transaction security with save points. Kevin Matsubara 2025-04-14 21:49:44 +02:00
feafaba447 Override ConfigureConventions to apply global restrictions on models. Kevin Matsubara 2025-04-14 21:49:18 +02:00
8a4e8a41f3 Add migration for restrictions. Kevin Matsubara 2025-04-14 21:30:34 +02:00
e4b92dedef Add restrictions in configuration and data annotations. Kevin Matsubara 2025-04-14 21:29:56 +02:00
5b90fa1242 Override SaveChangesAsync to automatically add audit data. Kevin Matsubara 2025-04-14 17:12:15 +02:00
d67d05d6a2 Use DbContext with options. Kevin Matsubara 2025-04-14 16:54:50 +02:00
cbcfb5536d Improve get Team by Id and include Coach and League. Kevin Matsubara 2025-04-14 13:15:53 +02:00
30c3621deb Return TeamDto instead of Team model for API. Kevin Matsubara 2025-04-14 12:55:08 +02:00
f8d1ddd758 Map controllers to program.cs file. Kevin Matsubara 2025-04-14 12:52:02 +02:00
4176958f17 Remove Weatherforecast example code. Kevin Matsubara 2025-04-14 12:50:30 +02:00
2934b45018 Optimise delete code with only 1 trip to database. Kevin Matsubara 2025-04-14 11:57:59 +02:00
16ddb2d336 Scaffold TeamsController in API project. Kevin Matsubara 2025-04-14 11:44:22 +02:00
8fc6bc96c0 Create new DbContext constructor with external Options. Kevin Matsubara 2025-04-14 10:50:13 +02:00
ba77fbd176 Update README with ASP.NET info. Kevin Matsubara 2025-04-08 23:03:37 +02:00
56fd0e44e7 Add API project to solution. Kevin Matsubara 2025-04-08 22:53:03 +02:00
73187855ba Create new ASP.NET API project. Kevin Matsubara 2025-04-08 22:51:12 +02:00
1c48a8c9c9 Add note about JOINs in SQL queries. Kevin Matsubara 2025-04-08 22:37:56 +02:00
001e78736c Add example user-defined function. Kevin Matsubara 2025-04-08 22:35:20 +02:00
093c663b31 Add example scalar query. Kevin Matsubara 2025-04-08 22:24:28 +02:00
99edd6c536 Add raw SQL examples. Kevin Matsubara 2025-04-08 22:17:23 +02:00
dd195dfddf Add custom SQL to create a view for Teams and Leagues with migration. Kevin Matsubara 2025-04-07 20:10:53 +02:00
9da28603c1 Add example function to project entity data into a DTO. Kevin Matsubara 2025-04-07 19:03:52 +02:00
fd6e601489 Update README with loading types. Kevin Matsubara 2025-04-07 16:57:44 +02:00
fc9d89ae97 Add example filter function and insert matches. Kevin Matsubara 2025-04-07 16:57:31 +02:00
3652a69730 Add example Explicit Loading function. Kevin Matsubara 2025-04-07 14:02:25 +02:00
8103c682cf Add example Eager Loading function. Kevin Matsubara 2025-04-07 13:50:57 +02:00
64965c3fef Update League model with initialized empty Teams list and no longer be nullable. Kevin Matsubara 2025-04-07 13:50:41 +02:00
6dcf07e90e Add example function inserting relational data objects. Kevin Matsubara 2025-04-07 13:26:10 +02:00
b56a19d8b8 Recreate consolidation of migrations after fixes. Kevin Matsubara 2025-04-07 11:58:11 +02:00
4d486114cb Add Coach configuration and link coach IDs to Teams. Kevin Matsubara 2025-04-07 11:55:27 +02:00
ab6b9b1b2a Fix seeded data for Teams to have LeagueId. Kevin Matsubara 2025-04-07 11:39:59 +02:00
8229e74c13 Remove consolidated migration. Kevin Matsubara 2025-04-07 11:36:19 +02:00
150f500675 Consolidate relationship migrations into single migration. Kevin Matsubara 2025-04-07 11:33:49 +02:00
0cacdd7b33 Add migration one to one Coach to Team relationship. Kevin Matsubara 2025-04-07 11:22:05 +02:00
b0e653ab0d Add one to one relationship between Coach and Team. Kevin Matsubara 2025-04-07 11:21:48 +02:00
1813bf6362 Add migration for many to many relationships between Matches and Teams. Kevin Matsubara 2025-04-07 11:11:46 +02:00
804943486f Add relationship and foreign key configurations between Match and Team. Kevin Matsubara 2025-04-07 11:09:42 +02:00
c73a72204d Update README with relationships. Kevin Matsubara 2025-04-07 10:53:03 +02:00
42edf6cccf Add migration to make relation League to Team nullable. Kevin Matsubara 2025-04-07 10:45:09 +02:00
e852f09f09 Make relation of League to Team nullable. Kevin Matsubara 2025-04-07 10:44:41 +02:00
1230476b27 Add migration to add relationship between League and Team. Kevin Matsubara 2025-04-07 10:43:29 +02:00
a0733b4ebb Add relationship between League and Team. Kevin Matsubara 2025-04-07 10:43:14 +02:00
b1f99dc57a Ensure database created on startup. Kevin Matsubara 2025-04-07 10:22:05 +02:00
e863015075 Add migration to add Team ID to Coach. Kevin Matsubara 2025-04-07 10:17:02 +02:00
48afe784d6 Add TeamId to Coach model. Kevin Matsubara 2025-04-07 10:16:41 +02:00
1197b9ecea Update README with rollback and list commands. Kevin Matsubara 2025-04-07 10:13:55 +02:00
b114a696a0 Update README with migration script. Kevin Matsubara 2025-04-06 23:35:37 +02:00
f630dfac2c Add migration for seeded leagues. Kevin Matsubara 2025-04-06 21:07:11 +02:00
7f5ecb9d3a Add Configurations for Teams and Leagues. Kevin Matsubara 2025-04-06 21:06:59 +02:00
fd915cc972 Add migration to add Name to League. Kevin Matsubara 2025-04-06 20:32:41 +02:00
808a6d6a3e Add Name property to League model. Kevin Matsubara 2025-04-06 20:30:17 +02:00
1a8cafbc4a Add migration to remove TeamID. Kevin Matsubara 2025-04-06 20:10:59 +02:00
278064b19b Remove Team ID from Team model. Kevin Matsubara 2025-04-06 20:10:36 +02:00
f137595a5a Add migration to add Match and League entities. Kevin Matsubara 2025-04-06 20:06:01 +02:00
a49717ff49 Update snapshot to make properties nullable. Kevin Matsubara 2025-04-06 19:59:00 +02:00
cccd9ba8e0 Change BaseDomainModel properties CreatedBy and ModifiedBy to be nullable. Kevin Matsubara 2025-04-06 11:51:15 +02:00
63a09998ac Add auditable properties to BaseDomainModel. Kevin Matsubara 2025-04-06 11:35:38 +02:00
4175eea10c Provide Team model with LeagueId and CoachId. Kevin Matsubara 2025-04-06 11:35:10 +02:00
2477d2b080 Create new domain models for Match and League. Kevin Matsubara 2025-04-06 11:34:53 +02:00
ba3c65d7a1 Move Id to BaseDomainModel and replace TeamId with regular Id. Kevin Matsubara 2025-04-06 11:27:13 +02:00
10d207cb44 add examples for ExecuteDelete and ExecuteUpdate functions. Kevin Matsubara 2025-04-05 23:33:19 +02:00
86b2e60e8c Add example delete for coach. Kevin Matsubara 2025-04-05 23:26:53 +02:00
f58ce8f120 Add update example with no-tracking for coach. Kevin Matsubara 2025-04-05 23:23:52 +02:00
963378f2e9 Add insert example. Kevin Matsubara 2025-04-05 23:06:01 +02:00
5a2a82b413 Comment out and remove unused code. Kevin Matsubara 2025-04-05 23:05:42 +02:00
29aebcea18 Update README. Kevin Matsubara 2025-04-05 21:58:50 +02:00
915434f44d Add example showing difference between directly toList or using IQueryable. Kevin Matsubara 2025-04-05 21:48:12 +02:00
1aae643a78 Add example query with tracking disabled. Kevin Matsubara 2025-04-05 21:29:48 +02:00
51eb8b117a Add examples with selecting specific columns and using a DTO. Kevin Matsubara 2025-04-05 20:54:19 +02:00
b715fd3150 Add example skip-and-take query function. Kevin Matsubara 2025-04-05 18:42:59 +02:00
f4978d215e Add example functions for ordered and grouped queries. Kevin Matsubara 2025-04-05 18:31:55 +02:00
e542616532 Add example counting query functions. Kevin Matsubara 2025-04-05 17:49:45 +02:00
2ef3859d2a Add example basic query functions. Kevin Matsubara 2025-04-05 17:23:44 +02:00
61b0e99f94 Create example queries in Console project. Kevin Matsubara 2025-04-05 00:19:28 +02:00
23a75282c1 Update README file. Kevin Matsubara 2025-04-04 23:31:13 +02:00
25ede5cc28 Add logging to Entity Framework Core workload. Kevin Matsubara 2025-04-04 20:12:03 +02:00
6e0167a051 Seed database with Teams. Kevin Matsubara 2025-04-04 19:36:19 +02:00
451fb50cd8 Add comment to DbContext about where the database file is created. Kevin Matsubara 2025-04-04 17:58:59 +02:00
5b3c661b67 Create initial migration. Kevin Matsubara 2025-04-04 17:28:08 +02:00
de4c0d390c Update README. Kevin Matsubara 2025-04-04 17:21:24 +02:00
a8b59a8ca2 Create DbContext file. Kevin Matsubara 2025-04-04 17:21:16 +02:00
f58f92d0e0 Install Sqlite database provider for Entity Framework in Data project. Kevin Matsubara 2025-04-04 17:20:57 +02:00
a53348294e Add reference to Data for the Console project. Kevin Matsubara 2025-04-04 17:15:01 +02:00
a1b318e8bc Install Microsoft.EntityFrameworkCore.Design NuGet package 9.0.3 version in the Console project. Kevin Matsubara 2025-04-04 17:12:49 +02:00
f1c4f4dda4 Add empty Console project to solution. Kevin Matsubara 2025-04-04 17:04:09 +02:00
601aff07c1 Add reference to Domain for the Data project. Kevin Matsubara 2025-04-04 16:25:46 +02:00
7bbe486bea Add Data and Domain projects to solution. Kevin Matsubara 2025-04-04 16:09:04 +02:00
c8b1f5c391 Create a clean solution and move all files. Kevin Matsubara 2025-04-04 16:06:58 +02:00
3db3e262e1 Install Entity Framework Core NuGet package in Data project instead of solution. Kevin Matsubara 2025-04-04 15:57:34 +02:00
28e6e98e93 Install NuGet package Entity Framework Core 9.0.3 version in solution. Kevin Matsubara 2025-04-04 15:54:56 +02:00
3fae448287 Add initial README. Kevin Matsubara 2025-04-04 15:54:24 +02:00
5e688a24d5 Add models for BaseDomainModel, Coach and Team. Kevin Matsubara 2025-04-04 15:41:45 +02:00

Commit Graph Select branches Hide Pull Requests master Mono Color

Commit Graph

Select branches

Hide Pull Requests

master