C#

Michael Sydney Balloni wrote:

general premise

1. File-based is simpler than server-based.
2. Four operations are easier to use than dozens.
3. And something simpler and easier to use is more productive.

Michael Sydney Balloni wrote:

Sometimes you need a yacht. But sometimes you just need a canoe.

Michael Sydney Balloni wrote:

Imagine how much SQLite code that would take, let alone the server setup for MySQL or some other RDBMS.

Eddy Vluggen wrote:

First of all, what is a lac and cr?

Thanks but, I just correct here that forget about lac and cr (it's Lakh and Crore), keep in mind that you have millions of files in a folder and I just want to insert the files name and its size in bytes into the database.

how do I bulk insert? and also keep in mind that system memory doesn't go high.

please suggest to me, how I can do it quickly and securely.

Ankur B. Patel wrote:

can anyone please help me out here, how can i implement this scenario in a better manner.

Kevin Marois wrote:

Anyone have a better approach?

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Task<List<ProjectHeaderEntity>> projectsTask = Task.Run(() => AppCore.BizObject.GetProjectHeaders(AppCore.AppCompany.Id).ToList());
Task<List<NavigationGroupEntity>> jobsTask = Task.Run(() => AppCore.BizObject.GetJobListHeaders(AppCore.AppCompany.Id).ToList());

// At this point, both tasks have started running.
// Since you know the number of tasks, you don't need Task.WhenAll; just await both tasks.

List<ProjectHeaderEntity> projects = await projectsTask;
List<NavigationGroupEntity> jobs = await jobsTask;

var dialogVm = new VendorsByProjectAndJobReportViewModel(projects, jobs);
DialogResultEx result = DialogService.ShowDialog(dialogVm, typeof(MainWindowView));

Richard Deeming wrote:

ConfigureAwait(false) tells the code that you don't want to us the same "execution context" to continue running the method after the task has completed.

Richard Deeming wrote:

I'd also be inclined to drop the closures.

Richard Deeming wrote:

And you don't really need Task.WhenAll here at all.

Kevin Marois wrote:

What's a 'closure'?

public void Foo()
{
    List<ProjectHeaderEntity> projects = null;
    await Task.Run(() => { projects = AppCore.BizObject.GetProjectHeaders(AppCore.AppCompany.Id).ToList(); });
    Console.WriteLine(projects.Count);
}

private sealed class <>_SomeRandomGeneratedName
{
    public List<ProjectHeaderEntity> projects;
    public Action TheAction;
    public void TheActualMethod()
    {
        this.projects = AppCore.BizObject.GetProjectHeaders(AppCore.AppCompany.Id).ToList();
    }
}

public void Foo()
{
    var closure = new <>_SomeRandomGeneratedName();
    closure.TheAction = new Action(closure.TheActualMethod);
    await Task.Run(closure.TheAction);
    Console.WriteLine(closure.projects.Count);
}

public void Foo()
{
    List<ProjectHeaderEntity> projects = await Task.Run(() => AppCore.BizObject.GetProjectHeaders(AppCore.AppCompany.Id).ToList());
    Console.WriteLine(projects.Count);
}

private static Func<List<ProjectHeaderItem>> TheCachedDelegate;

private static List<ProjectHeaderEntity> TheActualMethod()
{
    return AppCore.BizObject.GetProjectHeaders(AppCore.AppCompany.Id).ToList();
}

public void Foo()
{
    if (TheCachedDelegate == null)
    {
        TheCachedDelegate = new Func<List<ProjectHeaderItem>>(TheActualMethod);
    }
    
    List<ProjectHeaderEntity> projects = await Task.Run(TheCachedDelegate);
    Console.WriteLine(projects.Count);
}

Kevin Marois wrote:

I thought that WITHOUT WhenAll, the first would run, then the other one.

await Task.Run(() => ...); // Waits for this one to finish...
await Task.Run(() => ...); // then runs this one and waits for it to finish...
DoSomething(); // then does this.

Task a = Task.Run(() => ...); // Starts this one...
Task b = Task.Run(() => ...); // then starts this one...
await a; // then waits for the first one to finish...
await b; // then waits for the second one to finish...
DoSomething(); // then does this.

Task a = Task.Run(() => ...); // Starts this one...
Task b = Task.Run(() => ...); // then starts this one...
await Task.WhenAll(new[] { a, b }); // then waits for both tasks to finish...
DoSomething(); // then does this.

private async Task LoadProjects(VendorsByProjectAndJobReportViewModel vm)
{
    var projects = await Task.Run(() => AppCore.BizObject.GetProjectHeaders(AppCore.AppCompany.Id).ToList()).ConfigureAwait(false);
    vm.Projects = projects;
}

private async Task LoadJobs(VendorsByProjectAndJobReportViewModel vm)
{
    var jobs = await Task.Run(() => AppCore.BizObject.GetJobListHeaders(AppCore.AppCompany.Id).ToList()).ConfigureAwait(false);
    vm.Jobs = jobs;
}

private async Task ShowVendorsByProjectAndJobReport()
{
    WaitIndicatorVisibility = Visibility.Visible;
    
    var dialogVm = new VendorsByProjectAndJobReportViewModel();
    var tasks = new List<Task>
    {
        LoadProjects(dialogVm),
        LoadJobs(dialogVm),
    };
    
    await Task.WhenAll(tasks); // NB: No "ConfigureAwait" here
    DialogResultEx result = DialogService.ShowDialog(dialogVm, typeof(MainWindowView));
}