Issue referencing a portable class library from a SQL Server database project
I created a test solution in visual-studio-2013 that includes three projects. There's a database project, a PCL and a standard class library (let's call it SCL). They're all C# projects targetting .net-4.5.1.
If I add a reference from the database project to SCL, everything compiles without issues. If I also add a reference from database project to PCL, again everything compiles without any warnings in the build output.
However... there's this:
I noticed that little warning sign on the PCL. Unfortunately that's all I have. There's no build issues, no clues in the build output, no tooltip if I hover the sign... nothing. I couldn't find anything on the net about using (or not using) PCL as references for sqlclr apps either.
Anyone has an idea? Is there any problem with referencing a PCL from a SQL Server database project in Visual Studio? Why is it treated differently than SCL?
I can't do much test because right now I do not have a sql-server-2014 DB yet. I'm just planning ahead.
For others who find this question and wonder at the icon (as I did), this yellow symbol appears when the type library is built against a different .NET framework version:
This is usually the case with database projects using newer class library builds as Visual Studio 2013 creates .NET 4.0 projects by default*.
To remove the symbol, ensure your database project and class library use the same .NET Framework version, (e.g. 4.0, 4.5.1, etc.).
You can set the target framework of your database project via Properties->SQLCLR->Target Framework:
As far as I can tell it is just a warning flag, as code compiles, links and runs as expected.
* - .NET 4.5 when using 'New Project' from the database context menu of the SQL Server Object Explorer. Using SQL Express 2014 SP1
- Simple frame by frame video decoder library
- GCC no longer implements <varargs.h>
- Contents of IO buffer unknown == unsafe?
- Avoiding strcpy overflow destination warning
- Sort program not working, not sure why
- Fast & accurate atan/arctan approximation algorithm
- What's the difference between strtok_r and strtok_s in C?
- How memory address for pointer to arrays is same as an element in 2D array?
- Which is the best way to suppress "unused variable" warning
- How to use ellipsis in c's case statement?
- How can I exclude non-numeric keys? CS50 Caesar Pset2
- Fast ceiling of an integer division in C / C++
- Is there an invalid pthread_t id?
- How to Implement Universal Setter/Getter Functions for Interrupt-Driven Variables in Embedded C?
- How does SIMD (avx) processing work? for example, if I want 10 32 bit floats how do i fit in a 256 bit avx vector?
- FDCAN problems on STM32G4
- How does the call macro enable mutual recursion between functions f and g in this Hanoi Tower implementation?
- Running test on Rocket core CPU - global variable initialized to 0 is unsuccessful, output wrong value instead
- Interacting with C arrays without knowing the size
- Combination of two strings
- carriage return by fgets
- How to use special characters in C?
- Why does 1.0/100.0 == 0.1/10.0 give True?
- Is it correct to compare pointers in C?
- Force free() to return malloc memory back to OS
- How can I print to standard error in C with 'printf'?
- What is the standard behavior of fread in C on Windows?
- How is strtok removing lines it shouldn't have access to?
- Using array as smart point in C
- Assigning string to malloced 2d char array not working as intended