COMPSCI 335 写作、辅导SQL课程程序

” COMPSCI 335 写作、辅导SQL课程程序COMPSCI 335 1 A#2.4Assignment #2.4 ChinookRun a fluent dynamic query on the Chinook.db SQLite database.The query comes from stdin, in the following format (sample):ArtistsOrderBy Name DESCWhere ArtistId % 10 == 0Take 3Select new (ArtistId, Name)The first line contains the starting table.Each of the next line Contains the name of a LINQ operator, followed by a lambda givenin the string format expected by dynamic LINQ.The project will translate the above input into the following dynamic LINQ code:var seq2 = db.Artists.OrderBy (Name DESC).Where (ArtistId % 10 == 0).Take (3).Select (new (ArtistId, Name));FYI, this corresponds to the following standard LINQ code:var seq2 = db.Artists.OrderByDescending (id = Name).Where (id = id.ArtistId % 10 == 0).Take (3).Select (id = new {id.ArtistId, id.Name};The dynamic LINQ result, which here is a dynamic queryable sequence, will be furthertransformed And printed to stdout in JSON format:var res = JsonSerializer.Serialize (seq2 .AsEnumerable () .ToList ());COMPSCI 335 2 A#2.4Pretty printed result:[{ArtistId:150,Name:U2},{ArtistId:70,Name:Toquinho \u0026 Vin\u00EDcius},{ArtistId:200,Name:The Posies}]Submission: to automarker, one single C# source file, containing your code and thechinook EF scaffold (cf. the skeleton)Additional Packages:o Microsoft.EntityFrameworkCore.Sqliteo System.Linq.Dynamic.CoreSkelton folder contains:o a C# project file, including the additional packageso a C# source file, including the scaffoldo a Copy of chinook.dbo sample requests and responseso bat And sh script filesTables: .Dynamic LINQ functions: Select, Where, OrderBy, Skip, Take如有需要，请加QQ：99515681 或邮箱：99515681@qq.com

“