Click here to Skip to main content
14,664,421 members
Home » Discussions » .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: How to connect multiple computers to the same database? Pin
Dave Kreskowiak3-Dec-19 4:31
mveDave Kreskowiak3-Dec-19 4:31 
AnswerRe: How to connect multiple computers to the same database? Pin
Gerry Schmitz3-Dec-19 9:24
mveGerry Schmitz3-Dec-19 9:24 
QuestionNot able to connect to SQLite database if share is hidden Pin
JacquesUrlus21-Nov-19 8:18
MemberJacquesUrlus21-Nov-19 8:18 
AnswerRe: Not able to connect to SQLite database if share is hidden Pin
Dave Kreskowiak21-Nov-19 9:58
mveDave Kreskowiak21-Nov-19 9:58 
AnswerRe: Not able to connect to SQLite database if share is hidden Pin
Eddy Vluggen29-Nov-19 14:51
professionalEddy Vluggen29-Nov-19 14:51 
GeneralAnalytics Tool to Integrate with my application Pin
Supratik De20-Nov-19 19:18
MemberSupratik De20-Nov-19 19:18 
GeneralRe: Analytics Tool to Integrate with my application Pin
Pete O'Hanlon20-Nov-19 20:50
subeditorPete O'Hanlon20-Nov-19 20:50 
QuestionChanging the Include function of Entity Framework if association table is added Pin
simpledeveloper20-Nov-19 7:32
Membersimpledeveloper20-Nov-19 7:32 
I have two tables, Violations and NOVs, NovId is Foreign Key in Violations table, because it was OneToMany, but later when we needed ManyToMany relationships between these two tables, we created ManyToMany table where we transferred the association over there, how this new ManyToMany table is designed is, columns PKManyToMany, ParentTable, ChildTable, ParentId, ChildId, for NOVs and Violations relationships, ParentTable='Notice', ChildTable='Violations', earlier there was Linq Query as below:
var Violations = UnitOfWork.ViolationRepository.GetAll()
                    .Include("NOV")
                    .Include("NOV.CitedPartyData")
                    .Where(i => i.InspectionItemId == inspectionItemId)
                    .OrderBy(i => i.ViolationId).ToList();
                return Violations;

UnitOfWork.ViolationRepository.GetAll() gets all the Violations, but the new relationship is not directly to the NOVs table but ManyToMany table ParentTable='Notice', ChildTable='Violations', how can I include those records and then include the NOV table then include the NOV.CitedPartyData table, can we specify Include with condition and if the explicit foreign key is not created between table in the database, can Include still bring the records for the conditions.

I found that another big concern that I have is UnitOfWork.ViolationRepository doesn't have the ManyToMany table link (maybe Foreign Key), still can I use it in Include to load it or if I have to use UnitOfWork.OneToManyRepository, how can I use it?
- any help would be very very helful - thank you so much please.

modified 20-Nov-19 16:26pm.

AnswerRe: Changing the Include function of Entity Framework if association table is added Pin
Richard MacCutchan20-Nov-19 9:01
mveRichard MacCutchan20-Nov-19 9:01 
GeneralRe: Changing the Include function of Entity Framework if association table is added Pin
simpledeveloper20-Nov-19 10:30
Membersimpledeveloper20-Nov-19 10:30 
GeneralRe: Changing the Include function of Entity Framework if association table is added Pin
simpledeveloper21-Nov-19 6:51
Membersimpledeveloper21-Nov-19 6:51 
QuestionUsing Linq Join within the Where clause of another Linq Query Pin
simpledeveloper19-Nov-19 9:44
Membersimpledeveloper19-Nov-19 9:44 
AnswerRe: Using Linq Join within the Where clause of another Linq Query Pin
Gerry Schmitz20-Nov-19 7:00
mveGerry Schmitz20-Nov-19 7:00 
GeneralRe: Using Linq Join within the Where clause of another Linq Query Pin
simpledeveloper20-Nov-19 7:33
Membersimpledeveloper20-Nov-19 7:33 
QuestionDropping Columns referenced by other Tables Pin
simpledeveloper19-Nov-19 6:57
Membersimpledeveloper19-Nov-19 6:57 
AnswerRe: Dropping Columns referenced by other Tables Pin
Gerry Schmitz20-Nov-19 6:54
mveGerry Schmitz20-Nov-19 6:54 
GeneralRe: Dropping Columns referenced by other Tables Pin
simpledeveloper20-Nov-19 7:39
Membersimpledeveloper20-Nov-19 7:39 
GeneralRe: Dropping Columns referenced by other Tables Pin
simpledeveloper21-Nov-19 16:36
Membersimpledeveloper21-Nov-19 16:36 
QuestionLinq to check before it creates select Pin
simpledeveloper15-Nov-19 14:04
Membersimpledeveloper15-Nov-19 14:04 
SuggestionRe: Linq to check before it creates select Pin
Richard Deeming17-Nov-19 22:47
mveRichard Deeming17-Nov-19 22:47 
QuestionVB6 dll calls from WCF Pin
Emanuela Meraglia8-Nov-19 0:31
MemberEmanuela Meraglia8-Nov-19 0:31 
AnswerRe: VB6 dll calls from WCF Pin
Richard MacCutchan8-Nov-19 1:30
mveRichard MacCutchan8-Nov-19 1:30 
GeneralRe: VB6 dll calls from WCF Pin
Emanuela Meraglia8-Nov-19 2:11
MemberEmanuela Meraglia8-Nov-19 2:11 
AnswerRe: VB6 dll calls from WCF Pin
Richard Deeming8-Nov-19 1:31
mveRichard Deeming8-Nov-19 1:31 
GeneralRe: VB6 dll calls from WCF Pin
Emanuela Meraglia8-Nov-19 2:11
MemberEmanuela Meraglia8-Nov-19 2:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.