Error Message

ArgumentException was unhandled

Keyword not supported
Parameter name: id

            Dim dmscustomerid As Long = -1
            Dim cust As New Modus21.Customer
            cust.es.Connection.ConnectionString = MySQLDal.Global.GetModus21Connectionstring
            cust.Query.Where(cust.Query.ModusCustomerID.Equal(ModusCustomerID))
            If cust.Query.Load Then
                If Not IsNothing(cust.DMSCustomerID) Then
                    dmscustomerid = cust.DMSCustomerID
                End If
            End If
            Return dmscustomerid

Last Query is

   LastQuery "SELECT * FROM `customer` WHERE (`ModusCustomerID` = ?ModusCustomerID1 )" String

I changed the line

cust.es.Connection.ConnectionString = MySQLDal.Global.GetModus21Connectionstring

 to

cust.es.Connection.Name = "Modus"

But we still get the same error message.

Edit: I ran the Last Query in my MySQL Query Browser, replacing ?ModusCustomerID with one of our CustomerIDs and the query ran without issue.

The problem now seems to be that I'm getting a NullReferenceException on the get_CommandTimeout when I call the Query.Load.

I made sure Metadata Class Should Ignore Schema was checked and MetaData Class Should Ignore Catalog was checked when I generated the classes. I also check Target Multiple Databases.

This is my InitializeEntitySpaces Sub

1    EntitySpaces.Interfaces.esProviderFactory.Factory = New EntitySpaces.LoaderMT.esDataProviderFactory()
2    
3                m_connstring = My.Settings.ConnectionString
4                Dim conn As New EntitySpaces.Interfaces.esConnectionElement
5                conn.ConnectionString = m_connstring
6                conn.Name = "Live"
7                conn.Provider = "EntitySpaces.MySqlClientProvider"
8                conn.ProviderClass = "DataProvider"
9                conn.SqlAccessType = EntitySpaces.Interfaces.esSqlAccessType.DynamicSQL
10               conn.ProviderMetadataKey = "esDefault"
11               '// Assign the Default Connection
12               EntitySpaces.Interfaces.esConfigSettings.ConnectionInfo.Connections.Add(conn)
13               EntitySpaces.Interfaces.esConfigSettings.ConnectionInfo.Default = "Live"
14   
15               Dim modconn As New EntitySpaces.Interfaces.esConnectionElement
16               conn.ConnectionString = "datasource=127.0.0.1;Initial Catalog=modusstagingdatabase;User Id=blah;Password=blah"
17               conn.Name = "Modus"
18               conn.Provider = "EntitySpaces.MySqlClientProvider"
19               conn.ProviderClass = "DataProvider"
20               conn.SqlAccessType = EntitySpaces.Interfaces.esSqlAccessType.DynamicSQL
21               conn.ProviderMetadataKey = "esDefault"
22   
23               EntitySpaces.Interfaces.esConfigSettings.ConnectionInfo.Connections.Add(modconn)

For your second connection, you "Dim" a different object "modCon" and add it, but the code in between is still using "conn". It's not necessary for the name of the object to be different. The fact that conn.Name is different is sufficient.

See this FAQ for an example configless approach with two connections:

http://community.entityspaces.net/forums/thread/4769.aspx

Do not check "Target Multiple Databases". See the description of that option in the "Getting Started" PDF, or the more detailed explanation if Multi-provider mode in this FAQ:

http://community.entityspaces.net/forums/thread/3136.aspx

We probably should change the name of that option in the template to "Target Multiple Providers" to avoid confusion.

David, I'm glad it's Friday.

 Thank you for your help.