René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Unrelated tables join and query","articleBody":"I want abilty to query 2 tables like sql join, Those2 tables wont have any relationshp in the table. I have generated models cs files and dbcontext.cs file using EF command automatically.\n\nSELECT C.CCode, C.CName, P.PCode, P.PName \nFROM Client C\nINNER JOIN Product P ON C.MCode = P.MCode AND C.CCode = P.CCode....\n\nI have this code in startup.cs\npublic void ConfigureServices(IServiceCollection services)\n        {\n            try\n            {\n                \n                // Register IHttpContextAccessor\n                services.AddHttpContextAccessor();\n\n                // Register DBContext with IHttpContextAccessor\n                services.AddDbContext\u003cDBContext\u003e((serviceProvider, options) =\u003e\n                {\n                    var httpContextAccessor = serviceProvider.GetRequiredService\u003cIHttpContextAccessor\u003e();\n                    var connection = new SqlConnection(GetConnectionString(httpContextAccessor));\n\n                    // var creds = new Azure.Identity.DefaultAzureCredential();\n                    // var token = creds.GetToken(new Azure.Core.TokenRequestContext(new[] { \"https://database.windows.net/.default\" }));\n                    // connection.AccessToken = token.Token;\n\n                    options.UseSqlServer(connection);\n                });\n\n                int DefaultPageSize = Configuration.GetValue\u003cint\u003e(\"DefaultPageSize\");\n                int MaxPages = Configuration.GetValue\u003cint\u003e(\"MaxPages\");\n\n                services.AddGraphQLSchema\u003cDBContext\u003e(provider =\u003e\n                {\n                    provider.OnFieldCreated = (field) =\u003e\n                    {\n                        if (field.ReturnType.IsList \u0026\u0026 field.ReturnType.SchemaType.GqlType == GqlTypes.QueryObject \u0026\u0026 !field.FromType.IsInterface)\n                        {\n                            field.UseFilter().UseSort().UseOffsetPaging(defaultPageSize: DefaultPageSize, maxPageSize: MaxPages);\n                        }\n                    };\n                });...\n..............\n.........\n}.....\nhow and where I make these 2 tables related? what files would require changes? Client.cs, product.cs or dbcontext.cs or startup.cs?\n             ","author":{"url":"https://github.com/santhidhanuskodi23","@type":"Person","name":"santhidhanuskodi23"},"datePublished":"2026-01-13T11:07:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":6},"url":"https://github.com/491/EntityGraphQL/issues/491"}