Click here to Skip to main content
15,921,837 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Richard MacCutchan16-Oct-21 4:00
mveRichard MacCutchan16-Oct-21 4:00 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Eddy Vluggen16-Oct-21 4:18
professionalEddy Vluggen16-Oct-21 4:18 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Ankur B. Patel16-Oct-21 4:59
Ankur B. Patel16-Oct-21 4:59 
GeneralRe: How to get Millions of files from folder and bulk insert in database Pin
Gerry Schmitz16-Oct-21 11:04
mveGerry Schmitz16-Oct-21 11:04 
AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
OriginalGriff16-Oct-21 6:43
mveOriginalGriff16-Oct-21 6:43 
AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
Michael Sydney Balloni16-Oct-21 17:36
professionalMichael Sydney Balloni16-Oct-21 17:36 
AnswerRe: How to get Millions of files from folder and bulk insert in database Pin
jschell24-Oct-21 6:50
jschell24-Oct-21 6:50 
QuestionPredicateBuilder Question Pin
Kevin Marois15-Oct-21 5:24
professionalKevin Marois15-Oct-21 5:24 
I have this Linq-To-Sql query. I'm now going to introduce conditions that match the parameters:
public List<VendorsByProjectAndJobReportEntity> GetVendorsByProjectAndJobReportData(int appCompanyId,
                                                                                    List<int> projectIds, 
                                                                                    List<int> jobIds, 
                                                                                    List<PurchaseOrderType> purchaseOrderTypes)
{
    using (var dc = GetDataContext())
    {
        var results = (from j in dc.Jobs
                        join ac in dc.AppCompanies on j.AppCompanyId equals ac.Id
                        join p in dc.Projects on j.ProjectId equals p.Id
                        join poh in dc.PurchaseOrderHeaders on j.Id equals poh.JobId
                        join cl in dc.CompanyLocations on poh.VendorId equals cl.Id
                        where ac.Id == appCompanyId &&
                                !j.DeletedDT.HasValue &&
                                !p.DeletedDT.HasValue &&
                                (poh.POStatus != (int)PurchaseOrderPOState.Cancelled &&
                                poh.POStatus != (int)PurchaseOrderPOState.Draft)
                        select new VendorsByProjectAndJobReportEntity
                        {
                            ProjectId = p.Id,
                            ProjectInfo = $"{p.ProjectNumber.ToString()} - {p.ProjectName}",
                            JobId = j.Id,
                            JobInfo = $"{j.JobNumber.ToString()} - {j.Phase}",
                            VendorId = cl.Id,
                            VendorName = cl.Location,
                            PurchaseOrderType = (PurchaseOrderType)poh.PurchaseOrderType,
                            PurchaseOrderTotal = poh.Total,
                            ReportTitle = $"{ac.CompanyName} Vendors by Project and Job"
                        }).ToList();

        return results.OrderBy(x => x.ProjectInfo)
                        .ThenBy(x => x.JobInfo)
                        .ThenBy(x => x.PurchaseOrderTypeDesc)
                        .ThenBy(x => x.VendorName).ToList();
    }
}
I want to replace the Where clause with a PredicateBuilder, so I start out like this:
var predicate = PredicateBuilder.New<VendorsByProjectAndJobReportEntity>();
predicate = predicate.And(x => !x.DeletedDT.HasValue);
First, I don't want either Project or Job records if they're deleted. Which record is 'x' referring to in the PredicateBuilder?

The only way I can see making this work is to add both a ProjectDeletedByDT and JobDeletedBtDT to the entity and assigning both of those dates to it.

Anyone have a better approach?
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

AnswerRe: PredicateBuilder Question Pin
Eddy Vluggen15-Oct-21 14:44
professionalEddy Vluggen15-Oct-21 14:44 
QuestionTask.WhenAll ConfigureAwait Question Pin
Kevin Marois14-Oct-21 12:57
professionalKevin Marois14-Oct-21 12:57 
AnswerRe: Task.WhenAll ConfigureAwait Question Pin
Richard Deeming14-Oct-21 23:15
mveRichard Deeming14-Oct-21 23:15 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois15-Oct-21 4:53
professionalKevin Marois15-Oct-21 4:53 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Richard Deeming15-Oct-21 5:59
mveRichard Deeming15-Oct-21 5:59 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois15-Oct-21 6:29
professionalKevin Marois15-Oct-21 6:29 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois15-Oct-21 8:08
professionalKevin Marois15-Oct-21 8:08 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Richard Deeming17-Oct-21 21:58
mveRichard Deeming17-Oct-21 21:58 
GeneralRe: Task.WhenAll ConfigureAwait Question Pin
Kevin Marois18-Oct-21 4:01
professionalKevin Marois18-Oct-21 4:01 
QuestionCodility fails to compile even though it compiles in VS code? Pin
Cliff ludo13-Oct-21 6:41
Cliff ludo13-Oct-21 6:41 
AnswerRe: Codility fails to compile even though it compiles in VS code? Pin
BillWoodruff13-Oct-21 17:11
professionalBillWoodruff13-Oct-21 17:11 
Generalpass array to function Pin
Cliff ludo12-Oct-21 23:04
Cliff ludo12-Oct-21 23:04 
GeneralRe: pass array to function Pin
Richard Deeming12-Oct-21 23:25
mveRichard Deeming12-Oct-21 23:25 
GeneralRe: pass array to function Pin
Cliff ludo12-Oct-21 23:32
Cliff ludo12-Oct-21 23:32 
QuestionCreating An Async Method Pin
Kevin Marois7-Oct-21 11:02
professionalKevin Marois7-Oct-21 11:02 
AnswerRe: Creating An Async Method Pin
Richard Deeming7-Oct-21 21:41
mveRichard Deeming7-Oct-21 21:41 
GeneralRe: Creating An Async Method Pin
Kevin Marois8-Oct-21 6:00
professionalKevin Marois8-Oct-21 6:00 

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.