DevForce Community Forum

DevForce Classic : VARCHAR treated as NVARCHAR

Mon, 11 May 2015 15:13:46 -700

Author: kimj
Subject: VARCHAR treated as NVARCHAR
Posted: 11-May-2015 at 3:13pm

Here's a more recent example of a custom provider helper which is able to detect column information. The example below detects Xml data types and excludes columns of this type from parameter mapping for insert/update/delete statements.

public class CustomProviderHelper : IdeaBlade.Rdb.SqlServerProviderHelper {

   // Reset ALL strings to Ansi strings for select/insert/update/delete parms
   public override System.Data.DbType MapDbParameterType(System.Data.DbType pDbType) {
     return pDbType == System.Data.DbType.String ? System.Data.DbType.AnsiString : pDbType;
   }

   // This is called by the RdbAdapterProvider when building insert/update/delete statements.
   // We have enough column information here to detect XML types, and reset the parameter.DbType.
   public override void QualifyParameter(System.Data.IDbDataParameter pParameter, System.Data.DataRow pSchemaRow) {

     // Do base logic
     base.QualifyParameter(pParameter, pSchemaRow);

     // This was typed as an ansi string by MapDbParameter, reset to correct Xml datatype.
     if ((Type)pSchemaRow["ProviderSpecificDataType"] == typeof(System.Data.SqlTypes.SqlXml)) {
        pParameter.DbType = System.Data.DbType.Xml;
     }

     // There may be other useful schema info here too - like pSchemaRow["DataTypeName"]
   }
}

DevForce Classic : VARCHAR treated as NVARCHAR

Wed, 07 Jan 2015 08:21:50 -700

Author: JoshO
Subject: VARCHAR treated as NVARCHAR
Posted: 07-Jan-2015 at 8:21am

Posted on behalf of user toddgleason :

At first we tried the solution mentioned, involving aSqlServerProviderHelper (not sure if I got that class name right). This actually worked fine for most tables,but for any tables with XML columns, those would no longer come back correctlyfrom the DB. They needed to be encoded in NVARCHAR and no longer were.

I then began investigating whether an IAdapterProvidersolution was the way to go. Afterfiddling with this, and tracing through DevForce code in Reflector, I realizedthat this was only mostly dealing with the object schema and not reallyinvolved with the actual parameters involved in a fetch operation.

The solution I ended up with seems to be good. It hingedon the fact that we subclassed the PersistenceManager with a company-specificversion long ago, and have faithfully used our own class. This is critical because we created"new" versions of the GetEntity()/GetEntities()-style methods. (Thesereally should have been virtual to begin with; then our coverage would have beeneven more complete, but we think it's good enough for this case.)

Within our GetEntity()/GetEntities() methods, we"promote" the IEntityQuery into a company-specific class derived fromRdbQuery. (We do this for EntityQuery and RdbQuery but not pass-thruqueries.) And in our RdbQuery subclass,we override the Fetch() method of RdbQuery to do everything the base classdoes, but also tweak the query parameter types:

///

/// Thismethod is not intended to be called directly from your code.

///

///The dataset holding fetcheddata

///The data source key containingconnection information for the datasource.

///

/// Thismethod executes on the server side of the Persistence divide to

///retrieve data from the backend datasource.

///

publicoverride void Fetch(DataSet pDataSet, IDataSourceKey pDataSourceKey)

{

AdoHelper adoHelper = ((RdbKey)pDataSourceKey).AdoHelper;

RdbQuerySqlFormatter formatter = new RdbQuerySqlFormatter(adoHelper,(base.QueryStrategy == null) ? null : base.QueryStrategy.TransactionSettings);

CanonicalSqlQuery pQuery = formatter.BuildCanonicalQuery(this);

ParameterizedSql pParamSql = formatter.BuildSqlSelect(pQuery);

// SQLhas an issue with sending varchar columns as nvarchar; see

// http://lostechies.com/jimmybogard/2012/07/18/troubleshooting-sql-index-performance-on-varchar-columns/

// Aglobal type mapping change can be done,

// butit fails because XML columns need to be sent in Unicode instead of using the DBcollation, and conversion to ANSI breaks compatibility with such columns.

// Sothe solution is to instead, at fetch time, replace parameters marked asNVarChar with VarChar

// It'sunlikely we actually query by those XML parameters so this should be relativelysafe. This only affects

// theparameters sent out in the query, not the return type mappings.

// Oneother thing we do is that in our own PersistenceManager subclass's GetEntity()/GetEntities()calls, we "promote" all

//EntityQuery and RdbQuery objects to our derived objects, to guarantee invokingthis class.

foreach(var param in pParamSql.Parameters)

{

if(param.DbType == DbType.String)

param.DbType = DbType.AnsiString;

}

using(formatter)

{

formatter.Fetch(base.EntityType, pDataSet, pParamSql,this.CommandTimeout);

this.FetchSpans(pQuery, pDataSet, adoHelper, formatter);

if(base.ContainsSubquery && !this.SuppressQueryInversion)

{

this.FetchInverted(pDataSet, formatter, this);

}

You may also note that in here we could put extraintelligence in if we needed to apply this logic conditionally, such as byparameter name, or we could add to the query class to control the behavior.

The resulting solution has zero effect on the data typetransfer in either direction; it only affects the query parameters, which isexactly what we want.

Community Forum : DevForce "Cocktail" moved to Stackoverflow

Wed, 21 May 2014 10:47:40 -700

Author: IdeaBlade
Subject: DevForce "Cocktail" moved to Stackoverflow
Posted: 21-May-2014 at 10:47am

We've moved free community support for DevForce "Cocktail" to StackOverflow.com. By moving to StackOverflow,one of the largest communities of developers on the internet will be able tobenefit from your questions—and you from their answers.

You can still use all the great content in this forum. If you don’t find youranswer here then head on over to StackOverflow to post your question using the DevForcetag.

Community Forum : Get access to the MEF catalog

Tue, 20 May 2014 12:04:13 -700

Author: mgood
Subject: Get access to the MEF catalog
Posted: 20-May-2014 at 12:04pm

As with every dependency, you just need to make the catalog available through MEF so you can inject it where you need it. Here's how you can accomplish this.

public class AppBootstrapper : CocktailMefBootstrapper

{

private ComposablePartCatalog _catalog;

protected override ComposablePartCatalog PrepareCompositionCatalog()

{

// Hang on to the catalog

return _catalog = base.PrepareCompositionCatalog();

}

protected override void PrepareCompositionContainer(CompositionBatch batch)

{

base.PrepareCompositionContainer(batch);

// Add catalog to the MEF container

batch.AddExportedValue(_catalog);

}

[Export]

public class MainViewModel : Screen

{

[ImportingConstructor]

public MainViewModel(ComposablePartCatalog catalog)

{

}

Community Forum : Get access to the MEF catalog

Wed, 07 May 2014 07:52:00 -700

Author: kdev
Subject: Get access to the MEF catalog
Posted: 07-May-2014 at 7:52am

Hi,

I have a scenario with cocktail where I need to get access to the Mef Catalog to query the Part property (http://stackoverflow.com/questions/23497474/how-to-know-the-original-type-of-a-class-exported-as-an-interface-in-mef).

I need this information to implement the TargetGuard method of the INavigator. I check if an attribute decorate (or not) the class to allow (or refuse) the navigation.

I understand why it's not possible to publish this property as it's MEF dependant and the ICompositionProvider is "universal" for all type of IoC. But it's in some case really annoying to not have access to the catalog.

I also know I could write my own implementation of MEF and give it to cocktail but it looks it's a lot of work (need to redo the bootstrapper too) for just a small thing (in my point of view).

Could it be possible to add a class (dedicated to MEF) on Cocktail which, like EntityAspect.Wrap(), could wrap the cocktail MEF implementation and publish the Catalog ?

Right now I have a workaround but it's far to be clean. in the TargetGuard method, I create a new AggregateCatalog and fill it with the loaded assemblies. It would be nicer to use the catalog present in Cocktail

Edited by kdev - 07-May-2014 at 7:55am

DevForce 2012 : DevForce moved to Stackoverflow

Fri, 02 May 2014 12:16:06 -700

Author: IdeaBlade
Subject: DevForce moved to Stackoverflow
Posted: 02-May-2014 at 12:16pm

We've moved free community support for DevForce to StackOverflow. By moving to StackOverflow,one of the largest communities of developers on the internet will be able tobenefit from your questions—and you from their answers.

You can still use all the great content in this forum. If you don’t find youranswer here then head on over to StackOverflow to post your question using the DevForcetag.

DevForce Classic : DevForce moved to Stackoverflow

Fri, 02 May 2014 12:11:51 -700

Author: IdeaBlade
Subject: DevForce moved to Stackoverflow
Posted: 02-May-2014 at 12:11pm

Edited by IdeaBlade - 02-May-2014 at 12:14pm

DevForce 2009 : DevForce moved to Stackoverflow

Fri, 02 May 2014 12:10:03 -700

Author: IdeaBlade
Subject: DevForce moved to Stackoverflow
Posted: 02-May-2014 at 12:10pm

Edited by IdeaBlade - 02-May-2014 at 12:10pm

DevForce 2010 : DevForce moved to Stackoverflow

Fri, 02 May 2014 12:07:20 -700

Author: IdeaBlade
Subject: DevForce moved to Stackoverflow
Posted: 02-May-2014 at 12:07pm

Community Forum now on StackOverflow : DevForce moved to Stackoverflow

Fri, 02 May 2014 11:39:53 -700

Author: IdeaBlade
Subject: DevForce moved to Stackoverflow
Posted: 02-May-2014 at 11:39am

Edited by IdeaBlade - 02-May-2014 at 12:02pm

DevForce 2012 : DevForce vs. BreezeSharp

Fri, 02 May 2014 05:06:12 -700

Author: zbig
Subject: DevForce vs. BreezeSharp
Posted: 02-May-2014 at 5:06am

I have just received an e-mail announcing BreezeSharp. Looks great!

Before starting testing it ... is there any document/article which compares DevForce with BreezeSharp (I haven't found any such comparison)? If not ... would it be possible to indicate the most important differences?

Is there any 'hidden' assumption, that BreezeSharp will displace DevForce in the near future?

Z

DevForce 2012 : PredicateBuilder with ands / ors

Tue, 29 Apr 2014 10:55:02 -700

Author: DenisK
Subject: PredicateBuilder with ands / ors
Posted: 29-Apr-2014 at 10:55am

Assuming TSFinish is a property of MembersAndJobHistory,

var p7 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "TSFinish", FilterOperator.IsGreaterThanOrEqualTo, batch.PayPeriod);

var p8 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "TSFinish", FilterOperator.IsEqualTo, null);

var p9 = p7.Or(p8);

compositePred = CombinePreds(p1, p2, p3, p4, p5, p6, p9);

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 19:14:16 -700

Author: DenisK
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 7:14pm

Sorry, I missed that you are creating a new EntityManager upon each add.

If that's the case, the next thing to debug is, make sure the Import succeeds, and right after the import, search the EM's cache by using the EntityManager.FindEntities method. This should only return 1 entity of type Memo and that its EntityKey is what you'd expect.

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 15:17:32 -700

Author: BillG
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 3:17pm

What i dont understand is that when i pop up the dialog box for Memo form i am creating a new repository before importing the passed in memo object. Why would the previous one still be there?

going back to my example. on the list form, the user clicks Add, i create the memo and pass it to the dialog box form. in the dialog box form, i create a new repository/entity manager, import the passed in memo to the newly created entity manager. if i create a new repository/entity manager, clear it of all memos, and then do the import, should not that one be the only memo in the cache?

Bill

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 14:43:38 -700

Author: DenisK
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 2:43pm

As you've already noticed, DevForce will generate a temporary key for entity with a PK identity column.

Entities with temporary key and EntityState of Added are considered new entities by the EntityManager. What this means is that when you import entities with the same id and EntityState of Added, the later import doesn't overwrite the earlier import. But rather, the EntityManager will see the later entity as a new entity and will increment the id. So what you have are 2 entities with different ids.

I suspect that this is what's happening here. The fix is to set the EntityState to Unchanged before import and set them back to Added before persisting them to the db.

Community Forum now on StackOverflow : PredicateBuilder with ands / ors

Mon, 28 Apr 2014 13:41:52 -700

Author: BillG
Subject: PredicateBuilder with ands / ors
Posted: 28-Apr-2014 at 1:41pm

I know how to use Predicate Descriptions with Ands.

I have the following code

public IEnumerable<MembersAndJobHistory> GetMembersForBatchByEmployer(Batch batch)       {           IPredicateDescription compositePred;           PredicateDescription p1 = null, p2 = null, p3 = null, p4 = null, p5 = null, p6 = null;              p1 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "Status", FilterOperator.IsEqualTo, "A");           p2 = PredicateBuilder.Make(typeof (MembersAndJobHistory), "EmployerNo", FilterOperator.IsEqualTo,               batch.EmployerNo);           p3 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "PayVia", FilterOperator.IsEqualTo, "E");            if (!CommonControl.IsControlTrue("NoMonthlyDues"))           {               p4 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "Dues", FilterOperator.IsEqualTo, 0);            }           if (batch.BillYN != null)           {               p5 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "BillYN", FilterOperator.IsEqualTo, batch.BillYN);                        }           p6 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "TSStart", FilterOperator.IsLessThanOrEqualTo, batch.PayPeriodEnd);            compositePred = CombinePreds(p1, p2, p3, p4, p5, p6);            var query = Manager.MembersAndJobHistories               .Where(compositePred)               .OrderBy(m => m.SocSecNo);            var results = query.Execute();           return results;       }

       public IPredicateDescription CombinePreds(params PredicateDescription[] preds)      {           var nonNullPreds = preds.Where(pd => pd != null).ToArray();           var result = PredicateBuilder.And(nonNullPreds);           return result;      }

Now i need to add two more predicates to the query. Basically i want to And an Or. For example, and where
 TSFinish >= batch.PayPeriod or TSFinish is null

How do i fix my code to handle these 2 new predicates?

Bill

DevForce 2012 : PredicateBuilder with ands / ors

Mon, 28 Apr 2014 13:41:02 -700

Author: BillG
Subject: PredicateBuilder with ands / ors
Posted: 28-Apr-2014 at 1:41pm

I know how to use Predicate Descriptions with Ands.

I have the following code

public IEnumerable<MembersAndJobHistory> GetMembersForBatchByEmployer(Batch batch)       {           IPredicateDescription compositePred;           PredicateDescription p1 = null, p2 = null, p3 = null, p4 = null, p5 = null, p6 = null;              p1 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "Status", FilterOperator.IsEqualTo, "A");           p2 = PredicateBuilder.Make(typeof (MembersAndJobHistory), "EmployerNo", FilterOperator.IsEqualTo,               batch.EmployerNo);           p3 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "PayVia", FilterOperator.IsEqualTo, "E");            if (!CommonControl.IsControlTrue("NoMonthlyDues"))           {               p4 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "Dues", FilterOperator.IsEqualTo, 0);            }           if (batch.BillYN != null)           {               p5 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "BillYN", FilterOperator.IsEqualTo, batch.BillYN);                        }           p6 = PredicateBuilder.Make(typeof(MembersAndJobHistory), "TSStart", FilterOperator.IsLessThanOrEqualTo, batch.PayPeriodEnd);            compositePred = CombinePreds(p1, p2, p3, p4, p5, p6);            var query = Manager.MembersAndJobHistories               .Where(compositePred)               .OrderBy(m => m.SocSecNo);            var results = query.Execute();           return results;       }

       public IPredicateDescription CombinePreds(params PredicateDescription[] preds)      {           var nonNullPreds = preds.Where(pd => pd != null).ToArray();           var result = PredicateBuilder.And(nonNullPreds);           return result;      }

Now i need to add two more predicates to the query. Basically i want to And an Or. For example, and where
 TSFinish >= batch.PayPeriod or TSFinish is null

How do i fix my code to handle these 2 new predicates?

Bill

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 12:21:38 -700

Author: BillG
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 12:21pm

yes. It is an identity column.

Community Forum now on StackOverflow : why would Importing an entity fail?

Mon, 28 Apr 2014 11:53:54 -700

Author: DenisK
Subject: why would Importing an entity fail?
Posted: 28-Apr-2014 at 11:53am

Hi BillG,

Are you using an integer data type with Database Identity generation for your Memo's primary key?

DevForce 2012 : Need fancy verifier..

Mon, 28 Apr 2014 11:33:54 -700

Author: DenisK
Subject: Need fancy verifier..
Posted: 28-Apr-2014 at 11:33am

Unfortunately, we don't currently support the creation of custom message per property via VerifierResult. You can certainly suggest it on our DevForce UserVoice

Since a VerifierResult can only return one message for all properties specified, we have to somehow return specific VerifierResult for the specific property. That's why I suggested the approach above.

Community Forum now on StackOverflow : why would Importing an entity fail?

Sun, 27 Apr 2014 00:30:29 -700

Author: BillG
Subject: why would Importing an entity fail?
Posted: 27-Apr-2014 at 12:30am

I have the following situation. the uses clicks an add button on a form. I create the entity for the add button in question lets say "Memo"

var memo = Repository.CreateMemo(member);

then I call my dialog box to display the memo

MemoEditForm form = new MemoEditForm(memo);
DialogResult result = form.ShowDialog()

in the constructor for the MemoEditForm. I have the following.

InitializeComponent();
Repository = UnionRepository.CreateRepository();
Repository.ClearAllMemberMemos();
currentMemo = Repository.ImportMemberMemo(memo);
editMode = memo.EntityAspect.EntityState == EntityState.Added ? EditMode.Add : EditMode.Edit;
MemberMemoBS.DataSource = currentMemo;
currentMember = currentMemo.Member;
LoadData();

basically I create a new repository/entity manager. I make sure the entity manager is clear. I import the passed over newly created memo object and import it into the new entity manager. if the user enters all the fields in and then clicks "Save" I close the dialog box and refresh a grid with the new memo. If they click cancel, I remove the entity from the first cache.

This works for the first memo. I add a memo (I click cancel). I click add again and the import this time returns a null for currentMemo.

so my question is why would the import fail. this is my import method

     public MemberMemo ImportMemberMemo(MemberMemo memo)
        {
            if (memo == null || memo.EntityAspect.IsNullOrPendingEntity)
            {
               throw new ArgumentException("Imported memo is null or nullo");
            }
            // Don't bother if already attached to repository's manager
            if (memo.EntityAspect.EntityManager == Manager) return memo;

            ImportEntities(new Object[] { memo });
            return (MemberMemo)Manager.FindEntity(memo.EntityAspect.EntityKey);
        }

    private void ImportEntities(IEnumerable entities)
        {
            EnsureEntitiesAreUnmodified(entities);
            Manager.ImportEntities(entities, MergeStrategy.OverwriteChanges);
        }

DevForce 2012 : Need Advice on Entity Manager

Fri, 25 Apr 2014 09:47:50 -700

Author: jbiddle61
Subject: Need Advice on Entity Manager
Posted: 25-Apr-2014 at 9:47am

If you want the results of CalculateOwing to be part of the same database transaction, you need to call it before the Save completes and on the same EntityManager that the Save is using.

DevForce 2012 : Need fancy verifier..

Thu, 24 Apr 2014 15:06:19 -700

Author: katit
Subject: Need fancy verifier..
Posted: 24-Apr-2014 at 3:06pm

I'm still not sure how this will work. I don't have problem with triggering and processing properties. I don't even care which of those 3 properties triggered verifier.

I do want to somehow return return multiple messages along with properties.

Something like this: (obviously it's bad signature suggestion, but illustrates what I need)
return new VerifierResult(false, "MeesageForProperty1", "MessageForProperty2", properties.ToArray());

DevForce 2012 : Need fancy verifier..

Thu, 24 Apr 2014 14:58:59 -700

Author: DenisK
Subject: Need fancy verifier..
Posted: 24-Apr-2014 at 2:58pm

My apologies. I misunderstood your requirements.

Currently, ReasonEx property is the only one that's triggering this DelegateVerifier. And because of that, you're limited to providing one custom message.

Your requirement is that you want to provide custom message per each property that's involved in this validation. To do this, you have to attach a Verifier to the other 3 properties and make them trigger the validation. This is the only way that I can think of to do what you want.

See if you can try the following:

1. Create a DelegateVerifier that you would attach to these 3 properties. Let's call this DriverCarrierDelegateVerifier. Note that you can subclass the RequiredValueVerifier. This is a pre-defined DevForce Verifier.

See http://drc.ideablade.com/devforce-2012/bin/view/Documentation/validation-create-custom-verifier#HSubclassingapre-definedverifier for more details.

2. Within it, since you know which property is triggering the Verifier through TriggerContext, you can return a VerifierResult with its customized message per property.

3. In your ReasonEx DelegateVerifier, call,

var verifiersToExecute = new List { DriverCarrierDelegateVerifier };

verifierContext.VerifierEngine.Execute(entity, verifiersToExecute, verifierContext);

The above Execute call will trigger the DriverCarrierDelegateVerifier and in turn will trigger the 3 properties to be validated.

Please let me know how it goes.

DevForce 2010 : DevForce 6.1.16.1

Thu, 24 Apr 2014 14:25:33 -700

Author: LowOrbit
Subject: DevForce 6.1.16.1
Posted: 24-Apr-2014 at 2:25pm

Very nice, Thanks!!

DevForce 2010 : DevForce 6.1.16.1

Thu, 24 Apr 2014 14:24:38 -700

Author: sbelini
Subject: DevForce 6.1.16.1
Posted: 24-Apr-2014 at 2:24pm

Thanks for the update.

This is actually the issue.

Cocktail is set up to work with version 6.1.16.0.

We will notify you (and all users) once Cocktail is updated.

Sorry for the inconvenience.

DevForce 2012 : Need fancy verifier..

Thu, 24 Apr 2014 14:19:41 -700

Author: katit
Subject: Need fancy verifier..
Posted: 24-Apr-2014 at 2:19pm

Yes, I understand. Any of the 3 properties can trigger verifier. But what I want is _different_ messages over each field. So, if this verifier returns verification result for 3 properties I'd like to specify different messages too.

DevForce 2010 : DevForce 6.1.16.1

Thu, 24 Apr 2014 14:17:51 -700

Author: LowOrbit
Subject: DevForce 6.1.16.1
Posted: 24-Apr-2014 at 2:17pm

Yes. I am using the Cocktail 2010 (.NET 4). I am using the 1.1.6 version.

DevForce 2012 : Need fancy verifier..

Thu, 24 Apr 2014 14:17:17 -700

Author: DenisK
Subject: Need fancy verifier..
Posted: 24-Apr-2014 at 2:17pm

Hi katit,

In your DelegateVerifier, you should have access to the TriggerContext which gives you information on which property triggers the verifier. You can access it through TriggerContext.TriggerItem.MemberName.

DevForce 2010 : DevForce 6.1.16.1

Thu, 24 Apr 2014 14:13:59 -700

Author: sbelini
Subject: DevForce 6.1.16.1
Posted: 24-Apr-2014 at 2:13pm

Hi Robert, are you using Cocktail by any chance?