The type of one of the expressions int he join clause is incorrect. Type inference failed in the call to ‘join’

This error occurred while developing an application using entity framework code first database for the below Linq query using Join.

var query = from r in dbCltContext.Respondents
join rm in dbCltContext.Respondent_Meetings on r.Id equals rm.Respondent_Id
select new Scheduled_Meeting
RespondentID = r.Id,
RespondentName = r.Name,
MeetingID = rm.Id,
MeetingTitle = rm.Meeting_Title,
Start_Date = rm.Start_Date,
End_Date = rm.End_Date
return query.ToList();

Respondents looked like

public string Id { get; set; }
public string Name { get; set; }
public string Occuapation { get; set; }
public bool Active { get; set; }

Respondent_Meetings looked like

public int Respondent_Id { get; set; }
public string Meeting_Title { get; set; }
[Column(TypeName = "DateTime2")]
public DateTime Start_Date { get; set; }
[Column(TypeName = "DateTime2")]
public DateTime End_Date { get; set; }
public Respondent respondent { get; set; }

Because of the incorrect datatypes
public int Respondent_Id public string Id { get; set; }
Join threw an exception.


.Net interview questions in Sydney,Australia

1. What is dependency Injection?/ What is IOC?

2. Why did you choose AngularJS over other frameworks like Knockout etc.

3. What is the difference between MVC and MVVM?

4. What is a Private constructor?

5. Can an abstract class have a constructor?

6. How is Dependency Injection implemented in AngularJS?

7. Difference between Code First/Entity First in Entity Framework.

8. What types of Indexes did you implement in your database? What was the need for normalization?

9. How did you monitor your Sql stored procedure using Sql Profiler?

10. How do you initialize javascript functions as Javascript objects?

11. Difference between SOAP and Rest.

12. Pros and Cons of SOAP vs REST vs WebAPI.

13. Which Agile development methodology did you use in your project? SCRUM vs Agile. Story in Agile?

14. MVC vs MVVM. What is MVC and What is MVVM?

15. Difference between Window.Onload and document.ready? What did you mean by Window here?

16. Did you use require.js?

17. What type of Security did you implement in your project?

18. Do you prefer using inbuilt/opensource security libraries or prefer writing own custom libraries?

19. What steps did u perform for optimizing stored procedures?

20.Difference between Having and Where. Which one do you refer?

21. Difference between Abstract class and interface?

22. What is throttling in WCF?

23. Javascript Object initialization / assigning multiple functions as variables/properties of an object.

24. When can we use Empty Catch block?  All about try catch exception.

Converting Internal classes to public classes in a solution.

What are the issues if we convert an internal class to public class?

There is no harm in converting internal classes to public but there is no use as well.

Identify the inherited child class and exposed method with which you can access the properties of this class.

If initializing new methods can solve our purpose, try approaching that way and ignore about the access modifiers.

How to Decode HTML escape characters in XSLT

When working with XSLT we usually come across this scenario where we have to Encode or Decode html strings to be retrieved from database.

For ex: You store a string in Database.   <b>Hello World</b>  —- String to be displayed in bold when displayed to page.

This will be retieved by xml as    &lt;b&lt;Hello World&lt;b&lt;     —- Reason is XML will faill to generate as it will find < and > tags to be basic XML enclosing tags.

Hence in XSLT end include the attribute disable-output-escaping=”yes”

Hence the statement goes this way.

<xsl:value-of  select=”DisplayName”  disable-output-escaping=”yes”/>

Hence the Output    Hello World

Unable to debug Script Task in SSIS

If you are unable to debug your script even after setting a break point, You need to check the below.

Is your script task in Control Flow or Data Flow ?

  1. Script can be written in Control Flow using “Script Task”.
  2. Script can be written in DataFlow using a  “Script Component”.

We cannot debug script in DataFlow Task.

You can debug the script task in control flow by setting a breakpoint , But the same is not possible for a Script Component. Instead you can use MsgBox command to view that particular value.

You can also add DataViewers to view the output data.

If you need a particular reason for this…. Here are not accurate but supporting points..

1. Script Component can act as Source, Transform and Destination. So it’s not secure to allow debugging for such sensitive Data.

2. Microsoft has not yet provided this feature . We can expect this in future releases. (Simple answer)