Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is it necessary to create 5 external lists and 5 external content types, or can the lists indicate which data source should be used?

share|improve this question
    
can you give an example (in business terms) of how these content types would be parameterized? –  Derek Gusoff Sep 12 '12 at 14:09
    
Can I have a single Extenal Content Type called 'customer' when the California customers are in a db on one server and the New York customers are in another? Can the target of a ECT be parameterized as long as the schema is identical? –  Jeff Sacksteder Sep 13 '12 at 12:29
    
oh, I get it - same schema, different database connections. That's a great question. I would probably just create the separate ECTs, but I'd be interested to hear if there is a solution out there. –  Derek Gusoff Sep 13 '12 at 23:55
add comment

1 Answer 1

I think the best approach in this case would be to do the CRUD routing at the web-service/stored procedure level.

Alternatively you could write the models in Visual Studio and build logic into the CRUD methods to determine where the record should end up.

Depends where you feel more comfortable placing your business logic, if this is going to be common practice then I would say webservice.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.