Native C# in Stored Procedures

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715107

    Comments posted to this topic are about the item Native C# in Stored Procedures

  • Rob Bowser

    Grasshopper

    Points: 14

    :hehe: good1!

  • natalirozin

    SSC Enthusiast

    Points: 126

    :crying:

  • Cody Konior

    SSCarpal Tunnel

    Points: 4827

    Frankly, the date aside, I think it should have done this. SQLCLR is a massive pain in the butt to write, compile, then distribute the DLLs, then load onto a busy production system.

    Though I do completely understand why they wouldn't want to.

  • vikram.visingh

    SSC Veteran

    Points: 224

    That whats I thought.

    Who would use Visual Studio then.

  • twin.devil

    SSC-Insane

    Points: 22208

    Crackinnng :hehe:

  • greg.rowan

    Valued Member

    Points: 59

    Well played sir, well played.

  • Nestor Jarquin

    SSC Veteran

    Points: 295

    Ok, I'll admit it... I fell for it 🙁

    But then I was like, this sounds too good to be true... And it was...

  • Emito

    Mr or Mrs. 500

    Points: 544

    jejejeje nice!!!!

  • Martin_Burton

    SSCommitted

    Points: 1720

    Probably best not to even read most things posted today, been drawn into a few for the time it took me to read to the end.

    😀

  • davoscollective

    SSCertifiable

    Points: 6325

    Funny!

    Sad really though that they can't at least let you script in .net languages.

    I suppose there are some trusted/untrusted code issues to resolve.

    Postgres has had extensions for other languages for ages. http://www.postgresql.org/docs/current/interactive/external-pl.html

    Perl, Python, Tcl are built in as well as the pl/pgsql language, and others have added support for other languages, all done via a C interface. I'd love to see a bit of Iron Python in SSDT personally. In fact more love from the core visual studio team for database & BI projects generally. Sometimes it just feels like we're the poor cousins. The MDX calculations screen for example, is primitive compared to the level of debugging available to "real" .net projects.

    Maybe in SQL Server 2017?

  • Anders Pedersen

    SSChampion

    Points: 11410

    Good one!

    And demonstrates well why articles should be read in their entirety!

  • curran.davis

    SSC Rookie

    Points: 42

    *Grumble*

  • Jim_K

    SSCrazy

    Points: 2363

    Heh,

    And for half a second I was thinking, hmm, I might get easier access to regex functions. 😀

  • samalex

    SSCertifiable

    Points: 5358

    I was half way into an email to my other DBA and our Dev's with a link to the article when I double-checked to see if this was an April Fools post, which it was. Glad I saw that before I hit Send.

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply