fix: use ef core to build query instead of raw sql

fix: use ef core to build query instead of raw sql #8260