-
Great, that works! I have my M2M table setup as you described with only 2 columns that are FKs. Thanks very much.
-
I have a "Product" table, "Category" table, and a "ProductCategory" table that relates Products and Categories in a many-to-many relationship. If I have a single Product entity, what is the most efficient way to get the "CategoryCollection" of the related categories? The "ProductCategoryCollection" is of course accessible from the Product entity already
-
Great, thanks! Is there a possibility this will make it into a future release of ES? Seems like a useful thing. The API could allow the "Where" clause part to be passed in. Something maybe like this: Code: 1 // check existence by PK... 2 3 if (Employees.Exists(1)) 4 { 5 // it exists 6 } 7 8 9 // or, allow the column to be passed in somehow 10 11 if
-
Hi, I'd like to know the most efficient way to check if a record exists by searching on a single column. I don't need the whole entity, I just want to know if a row exists in the table that matches my criteria. Here's the code I'm trying right now, based on a database table called "Product": Code: 1 public bool ProductExists( string nameToFind) 2 {
-
That worked! thanks for the quick reply Just read your second reply. I have mine mapped to "object" atm and it's generating and compiling fine. Will report back as I do more testing/development with this.
-
I'm using SQL Server 2008 and the new "geography" spatial data type. It looks like ES doesn't support that yet. Can I just tell ES to ignore just that column when I generate the templates? I want to use ES for loading/saving/querying all other columns on this table, but I can handle this column in some custom code in the partial class. Can ES do this
-
I'm working with a legacy database and adding my own new tables with a special "WA_" prefix on them, and then using ES2009 against those "WA_" tables. It's a pain to have to go into my ES MetaData and manually remove the "WA_" prefix from each table name in the alias. For example, even though my table is named "WA_Product" I want the ES generated entity