This is a migrated thread and some comments may be shown as answers.

[Solved] Detach issue

2 Answers 101 Views

Data Access Free Edition

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Oscar asked on 14 Oct 2015, 05:30 PM

Hi.I am using DataAcess Q1 2015, when use CreateDetachCopy the graph does not fill it as indicated in fetchstrategy. For example, the following code does not bring data Fac_Clientes

try

{

using (FluentModel context = new FluentModel())

{

Telerik.OpenAccess.FetchOptimization.FetchStrategy fetchStrategy = new Telerik.OpenAccess.FetchOptimization.FetchStrategy();

context.FetchStrategy = fetchStrategy;

fetchStrategy.LoadWith<Ag_huecos>(h => h.Cc_pas);

fetchStrategy.LoadWith<Ag_huecos>(h => h.Ag_tramos);

fetchStrategy.LoadWith<Ag_huecos>(h => h.Pac_paciente);

fetchStrategy.LoadWith<Ag_huecos>(h => h.Ag_agenda);

fetchStrategy.LoadWith<Ag_huecos>(h => h.Pac_tarjetas);

fetchStrategy.LoadWith<Pac_tarjetas>(h => h.Pac_polizasxpaciente);

fetchStrategy.LoadWith<Pac_polizasxpaciente>(h => h.Fac_polizas);

fetchStrategy.LoadWith<Fac_polizas>(h => h.Fac_clientes);

var query = (from p in context.Ag_huecos

where idagenda.Contains(p.Idagenda)

&& p.Fechahorainicio > dia

&& p.Fechahorainicio < dia.AddDays(1)

select p).ToList();

Telerik.OpenAccess.FetchOptimization.FetchStrategy fetchStrategydetach = new Telerik.OpenAccess.FetchOptimization.FetchStrategy();

fetchStrategydetach.LoadWith<Ag_huecos>(h => h.Cc_pas);

fetchStrategydetach.LoadWith<Ag_huecos>(h => h.Ag_tramos);

fetchStrategydetach.LoadWith<Ag_huecos>(h => h.Pac_paciente);

fetchStrategydetach.LoadWith<Ag_huecos>(h => h.Ag_agenda);

fetchStrategydetach.LoadWith<Ag_huecos>(h => h.Pac_tarjetas);

fetchStrategydetach.LoadWith<Pac_tarjetas>(h => h.Pac_polizasxpaciente);

fetchStrategydetach.LoadWith<Pac_polizasxpaciente>(h => h.Fac_polizas);

fetchStrategydetach.LoadWith<Fac_polizas>(h => h.Fac_clientes);

var detachedContact = context.CreateDetachedCopy<List<Ag_huecos>>(query, fetchStrategydetach);

[Solved] Detach issue

2 Answers, 1 is accepted