Using multiple contexts .Net core

Question

My project depends on 2 different DB in 2 different projects and I want to make a join between 2 tables from each other and this my API code I've used

            var mBranch = (from Branch in _context.M_Branch.Where(p => p.BrnchNo == id)
                       join Dalel in _Erp_Context.Dalel on Branch.BrnchDebit equals Dalel.DalelNo into bt
                           from tt in bt.DefaultIfEmpty()
                           select new M_Branch
                           {
                               BrnchNo = Branch.BrnchNo,
                               BrnchCredit = Branch.BrnchCredit,
                               BrnchDalelDebit = tt.DalelDesc,
                               BrnchDebit = Branch.BrnchDebit,
                               BrnchDalelCredit = tt.DalelDesc,
                               BrnchDesc = Branch.BrnchDesc,
                               BrnchNotice = Branch.BrnchNotice,
                               BrnchUserNo = Branch.BrnchUserNo
                           }).FirstOrDefault();

but it says I can't use 2 different DB Context so I ended up with this solution I've found EntityFramework context across multiple projects or joining between two contexts

but it always gets me this error

System.NullReferenceException: Object reference not set to an instance of an object.

what's the solution and what's the best way to deal with Contexts more regularly and don't affect in memory or performance

Martin Staufcik · Accepted Answer · 2020-04-04 17:42:02Z

0

You might use a synonym in your database. You could create a synonym of Dalel table in _context database, or you could create M_Branch synonym in _Erp_Context, whichever makes more sense. Then you would be able to add these synonyme tables into your context in EF.

This post shows an example of using a synonym with EF: Entity Framework Code First with SQL Server Synonyms

edited Apr 4, 2020 at 17:42

answered Apr 4, 2020 at 17:31

Martin Staufcik

9,6728 gold badges57 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hazem Over a year ago

I've used "Views" in SQL and received it as a class in VS. and Thank you for your answer.

Collectives™ on Stack Overflow

Using multiple contexts .Net core

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related