C# Equivalent of VB "WITH"

Gary King

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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 King15y ago
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 King15y ago
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;
Vulpes15y ago
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 King15y ago
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!!!
Vulpes15y ago
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.