Click here to Skip to main content
15,886,026 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have dig on the net but unfortunately did not get the proper solution:

In my application, I am supposed to use .Net 3.5 SP1. Application should be Database independent that is why we are using entity framework. I am able to create app for single DB but for multiple DB (Database : Oracle,SQL) when I am passing connection string in EntityConnection, it is giving errors ( Like Password keyword not supported in connection string). when I am using the same connection string for single DB then it is working fine.

Below constructors are there in edmx designer code file.

/// <summary>
        /// Initializes a new unbSQLEntities object using the connection string found in the 'unbSQLEntities' section of the application configuration file.
        /// </summary>
        public unbSQLEntities() : base("name=unbSQLEntities", "unbSQLEntities")
        {
            this.ContextOptions.LazyLoadingEnabled = true;
            OnContextCreated();
        }
    
        /// <summary>
        /// Initialize a new unbSQLEntities object.
        /// </summary>
        public unbSQLEntities(string connectionString) : base(connectionString, "unbSQLEntities")
        {
            this.ContextOptions.LazyLoadingEnabled = true;
            OnContextCreated();
        }
    
        /// <summary>
        /// Initialize a new unbSQLEntities object.
        /// </summary>
        public unbSQLEntities(EntityConnection connection) : base(connection, "unbSQLEntities")
        {
            this.ContextOptions.LazyLoadingEnabled = true;
            OnContextCreated();
        }


Please help me.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900