1

I am trying to execute the below query

 from st in _context.tbl_A
 join ex in _context.tbl_B on st.ApplicantId equals ex.ApplicantId     
 join de in _contextCNS.tbl_C on st.DegreeId equals de.ID
 where st.ApplicantId == AppId

On Executing the query I am getting ERRROR -------

System.ArgumentNullException: Value cannot be null. Parameter name: entityType at Microsoft.EntityFrameworkCore.Utilities.Check.NotNull[T](T value, String parameterName) at Microsoft.EntityFrameworkCore.SqlServerMetadataExtensions.SqlServer(IEntityType entityType)

Thank you in advance

TiyebM
  • 2,684
  • 3
  • 40
  • 66
Nikhilesh Shinde
  • 29
  • 1
  • 4
  • Don't post all your project here. Make small and simple sample that shows your problem only. It is really hard to read. – RredCat Mar 14 '17 at 09:09
  • https://stackoverflow.com/a/54659045/3408531 – TiyebM Jun 08 '21 at 11:18
  • Does this answer your question? [How to inner join tables from different Data Context?](https://stackoverflow.com/questions/1537805/how-to-inner-join-tables-from-different-data-context) – TiyebM Jun 08 '21 at 11:21

1 Answers1

0

I notice that you are joining on a nullable columns please check this or this Or other sources addressing "joining on a nullable"

Basically

you should specify a default value for the nullable

Or

Ignore the records having a value of null inside the where clause

Community
  • 1
  • 1
Modar Na
  • 873
  • 7
  • 18