C# Equivalent of VB WITH

Question

In C# is there an equivalent of the VB With / End With?

The only thing that I can find is Using, but this does not appear to work in the same way as With....
For example, in VB I can define which object I am working with and then not use the object name again - something like this....

With myObject

.Color = "Red"

.FontSize = "12"

End With

In the above example, I only have to type "myObject" once.

Is this also possible in C#?

Thanks
Gary

Vulpes · Answer

If you're still using VS 2005 then it doesn't support either 'var' or the 'object initializer' syntax which were not introduced until VS 2008. However you can still do the following to save typing if you're adding 12 parameters: SqlCommand cmdPermitHeader_INSERT = new SqlCommand(p_PermitHeader_INSERT dbConnPermit); cmdPermitHeader_INSERT.CommandType = CommandType.StoredProcedure; SqlParameterCollection p = cmdPermitHeader_INSERT.Parameters; p.Add(@FirstName SqlDbType.NVarChar).Value = FirstName.Text;

Gary King · Answer

Excellent - THANK YOU SO MUCH!!!! Ok not exactly what I was thinking of (along the lines of VB With / End With) but this will do.

Gary King · Answer

I may be misisng the point here but Visual Studio doesn't allow var Here is the code that I currently have - there are in fact 12 parameters needed for the Stored Proc: SqlCommand cmdPermitHeader_INSERT = new SqlCommand(p_PermitHeader_INSERT dbConnPermit); cmdPermitHeader_INSERT.CommandType = CommandType.StoredProcedure; cmdPermitHeader_INSERT.Parameters.Add(@FirstName SqlDbType.NVarChar).Value = FirstName.Text; How would you change that so that I could use: p.Add(@FirstName SqlDbType.NVarChar).Value = FirstName.Text;

Vulpes · Answer

If it's an object with a long name then you could assign it to a local variable with a short name and then use that: var p = mySqlCommand.Parameters; // now work with 'p' Incidentally when I said object with no constructor in my earlier post I should have said an object with a parameterless constructor though you can also use similar syntax with an object whose constructor does takes parameters: var myObject = new SomeType(someArg) { Color = Red FontSize = 12 };

Gary King · Answer

Thanks for the info..... The object in question is a SqlCommand of type StroedProcedure. What I wanted to do is add all the SP Parameters without having to type the object name for each parameter. Oh well!!!

Vulpes · Answer

There's no direct equivalent of the 'With' statement in C#. If you're creating a new object of some type which has some public properties but no constructor then you can do this: var myObject = new SomeType { Color = Red FontSize = 12 }; but you can't change the properties of an existing object like this.

C# Equivalent of VB "WITH"