#Piotr #Nogalski - C# Blog

Drop User: The database principal owns a schema in the database, and cannot be dropped

2009-08-23T12:00:00.000+02:00

Dropping a user which owns a schema will result in the error message “The database principal owns a schema in the database, and cannot be dropped”.

To solve this you can assign the schema back to its base principal with the ALTER AUTHORIZATION message, or it can be moved to another user/principal.
If for example user Test1 owns the db_owner schema and you want to drop Test1 but don’t have another user to move the schema to you can type:

ALTER AUTHORIZATION ON SCHEMA::db_owner TO db_owner
(or for example db_datawriter if that was the case and so on)

If you wanted to move the schema to another user the syntax would be:

ALTER AUTHORIZATION ON SCHEMA:: TO userName

Create and Install Temporary Certificates in WCF

2009-06-11T13:13:00.002+02:00

You can find full article here

Most important parts:
1) Create a Certificate to Act as Your Root Certificate Authority

makecert -n "CN=RootCATest" -r -sv RootCATest.pvk RootCATest.cer

2) Create and Install Your Temporary Service Certificate

makecert -sk MyKeyName -iv RootCATest.pvk -n "CN=tempCert" -ic RootCATest.cer -sr localmachine -ss my -sky exchange -pe tempCert.cer

3) In Client config set RevocationMode to "NoCheck"

<behaviors>
<endpointBehaviors>
<behavior name="NewBehavior">
<clientCredentials>
<serviceCertificate>
<authentication *revocationMode="NoCheck" />
</serviceCertificate>
</clientCredentials>
</behavior>
</endpointBehaviors>
</behaviors>
<client>
<endpoint behaviorConfiguration="NewBehavior" ….>
</endpoint>
</client>

"Add Service Reference" 16384 quota

2009-06-09T11:29:00.003+02:00

If you got a problem with adding large WCF service into your Visual Studio sollution via "Add Service Reference" you can use following sollution.

You need to edit devenv.exe.config (default located in c:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\) and add larger quota info to IMetadataExchange binding. This configuration will be used by VS and it is used for netTcpBinding.

<configuration>
.
.
.
<system.serviceModel>
<client>
<endpoint name="net.tcp" binding="netTcpBinding" bindingConfiguration="bc" contract="IMetadataExchange" />
</client>
<bindings>
<netTcpBinding>
<binding name="bc" maxReceivedMessageSize="512000">
<readerQuotas maxNameTableCharCount="163840" />
<security mode="None"/>
</binding>
</netTcpBinding>
</bindings>
</system.serviceModel>
.
.
.
</configuration>

Finding objects in Generics with List.Find()

2009-05-04T14:20:00.006+02:00

Simple class:

public class Person
{
   public int ID { get; set; }
   public int Name { get; set; }

   public Person(int id, string name)
   {
      ID = id;
      Name = name;
   }
}

Usage code:

//Add some objects
List myList = new List();
myList.Add(new Person(1, "Person 1"));
myList.Add(new Person(2, "Person 2"));
myList.Add(new Person(3, "Person 3"));

//Find a specific object
Person myLocatedObject = myList.Find(delegate(Person p) {return p.ID == 1; });

Thanks Andrey for good example (original article)

Fixing Firefox Slowness with local developement server on Vista

2008-05-29T19:00:00.002+02:00

It's really an anoying problem. Firefox runs like a turtle on local developement server on Vista:( But there is a nice sollution for this one:
In Firefox, goto about:config, filter by "network.dns.disableIPv6" and double-click to set to true.

Here you go :)

32 bit ODBC Datasources on 64 bit Vista

2008-05-29T18:47:00.001+02:00

Having problem with the 64 bit ODBC Datasources manager on Vista ?
The launcher for 32 bit version is located under:
C:\Windows\SysWOW64\odbcad32.exe

How to reset identity seed in Sql Server

2008-02-11T15:47:00.000+01:00

Sometimes you need to reset indentity seed in your database table. There is a nice way to achive that (sql command):

DBCC CHECKIDENT('table_name', RESEED, 0)

How to remove primary key column in DataTable

2008-01-22T10:07:00.000+01:00

Sometimes you need to drop column from DataTable which is marked as PrimaryKey (else you will get an exception). There's a nice way to accomplish that.

DataTable.PrimaryKey = null;

So simple, so nice :)

Deleting all svn folders recursively

2008-01-03T11:33:00.000+01:00

Offtopic post: If you want eaisly delete all svn subfolders just use this clever sollution under Windows with usage of Total Commander:

Invoke a search (Alt+F7) from the projects root directory
Search for .svn (or _svn) - it depends on your settings
When the results are displayed, click the “Feed to listbox” button (bottom right)
In the list that appears select all the folders and delete (Shift-F8)

BlogEngine.Net

2007-11-20T11:22:00.000+01:00

I have just created Polish Localization for BlogEngine.net. Hope you can find it soon in official release of BlogEngine.net localization pack.
http://www.codeplex.com/blogengine

Welcome to my blog

2007-11-20T09:12:00.000+01:00

Hi Everybody, welcome to my C# blog. Hope you find here many interesting articles in the future.
Best Regards
Piotr Nogalski