Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Difference Between Class Library Project and SQL CLR Project

RSS
Modified on Fri, Nov 14, 2008, 7:40 PM by Administrator Categorized as Visual Studio and Developer Tools
In a SQL-CLR .csproj file, the <ProjectGroup> node contains two nodes not found in a Class Library .csproj file: (1) <ProjectTypeGuids>, and (2) <NoStandardLibraries>. If you remove these two nodes, you will be able to open the SQL-CLR project as a Class Library.

Excerpt from a CSPROJ File for a SQL-CLR Project

<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
    <ProjectTypeGuids>{c252feb5-a946-4202-b1d4-9916a0590387};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
    <ProductVersion>8.0.50727</ProductVersion>
    <SchemaVersion>2.0</SchemaVersion>
    <ProjectGuid>{136D1F6D-D797-4078-97EC-EEC6B2FADBE0}</ProjectGuid>
    <OutputType>Library</OutputType>
    <NoStandardLibraries>false</NoStandardLibraries>
    <AssemblyName>Maestro.SqlClr</AssemblyName>
    <RootNamespace>Maestro.SqlClr</RootNamespace>
    <PermissionLevel>1</PermissionLevel>
  </PropertyGroup>

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.