DevForce Community Forum : sqlbulkcopy connection string http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : sqlbulkcopy connection string Tue, 12 May 2026 22:39:35 -700 Fri, 16 Aug 2013 17:10:07 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4277 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ sqlbulkcopy connection string : You can access the application... http://www.ideablade.com/forum/forum_posts.asp?TID=4277&PID=16742#16742 Author: smi-mark
Subject: 4277
Posted: 16-Aug-2013 at 5:10pm

You can access the application properties and populate an EntityConnectionStringBuilder and access the ConnectionString property or you can instantiate an EntityManager and use this useful extension method I wrote.



    public static class EntityManagerFns
    {
        public static string GetConnectionString(this EntityManager entityManager, string keyName)
        {
            var resolver = entityManager.DataSourceResolver.ProbedKeyResolver;
            var key = (ClientEdmKey)resolver.GetKey(keyName, string.Empty, true);
            return key.ConnectionString;
        }
    }


You can then call Manager.GetConnectionString("WhateverEntities");

We use CodeFirst exclusively now, so I can't remember if the connection string returned will be an EF string or the raw SQL string.
]]> Fri, 16 Aug 2013 17:10:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4277&PID=16742#16742 sqlbulkcopy connection string : For doing an import on a large... http://www.ideablade.com/forum/forum_posts.asp?TID=4277&PID=16740#16740 Author: BigA25
Subject: 4277
Posted: 16-Aug-2013 at 3:20pm

For doing an import on a large number of rows (excel file) I decided to use sqlbulkcopy to have good performance.
The problem is that this requires a direct link to the database through a connection string. 

Is there a way to get this connection string from ideablade anywhere?
]]> Fri, 16 Aug 2013 15:20:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4277&PID=16740#16740