MS SQL Server Questions
Posted in .NET on August 18th, 20071. What is a SQL Server Instance?
See the answer here
2. How to find the port number that an instance is listening to?
here
The SQL Server Networking Utility mentioned is svrnetcn.
Archive for the '.NET' Category
Open source .NET frameworks/APIs I am interested in
Posted in .NET on December 31st, 2006How to find out if an assembly is compiled in Debug or Release mode?
Posted in .NET on August 31st, 2006Via Scott.
> csc /debug BuildFind.cs
Microsoft (R) Visual C# .NET Compiler version 7.10.6001.4
for Microsoft (R) .NET Framework version 1.1.4322
Copyright (C) Microsoft Corporation 2001-2002. All rights reserved.> BuildFind.exe BuildFind.exe
Run time Optimizer is enabled : False
Run time Tracking is enabled : True
BuildFind.exe is a DEBUG Build….> csc /o BuildFind.cs
Microsoft (R) Visual C# .NET Compiler version 7.10.6001.4
for Microsoft (R) .NET Framework version 1.1.4322
Copyright (C) Microsoft Corporation 2001-2002. All rights reserved.> BuildFind.exe BuildFind.exe
BuildFind.exe is a RELEASE Build….
Use xcopy in post-built event of Visual Studio.Net
Posted in .NET on August 31st, 2006The data access example shipped with the Microsoft enterprise library showed an example:
xcopy /C /I /R /Y “$(ProjectDir)dataConfiguration.config” “$(ProjectDir)$(OutDir).”
copy “$(ProjectDir)DataAccessQuickStart.exe.manifest” “$(ProjectDir)$(OutDir).”
where the options for xcopy are:
/C Continue copying even if an error occurs.
/I If in doubt always assume the destination is a folder
e.g. when the destination does not exist./R Overwrite read-only files.
/Y (Windows 2000 only) Suppress prompt to confirm overwriting a file.
may be preset in the COPYCMD env variable.
More detail of the xcopy command can be found here.
Useful scripts for .Net development
Posted in .NET on August 3rd, 2006While looking at the samples for the Microsoft Enterprise Library for .Net, I found couple of useful scripts:
Visual Studio.Net: shortcuts
Posted in .NET on July 5th, 2006- Alt + Shift + Enter:
- Ctrl + Space:
- Ctrl + Shift + Space:
- Ctrl + K Ctrl + I:
- Ctrl + M + O: folds all code
- Ctrl + M + P: expands all folds
- Ctrl+K Ctrl+C: comments out the code
- Ctrl+K Ctrl+U: uncomments the code section
- Ctrl + K Ctrl + F:
- Ctrl + F:
- Ctrl + Shift + F:
- F5:
- Ctrl + F5:
- F10:
- F11:
- F7:
- Shift + F7:
- F8:
- F12: go to definition
- Shift + F12: go to reference
- Esc:
- Ctrl + Tab:
- Ctrl + S:
- Ctrl + Shift +S:
- Shift + F10:
Visual Studio.Net: open a solution from command line
Posted in .NET on July 2nd, 2006c:>\path\to\devenv.exe /nosplash /path/to/vss/solution/file
I have a NUnit solution containing test classes I need to open this solution from time to time. I configured an entry in my application launch using devenv command line switches. Now I just need to type something like “csharpunittest” to launch the unit test solution. Sweet.
Poor man’s MS SQL server replacement
Posted in .NET on July 2nd, 2006I use these free tools as MS SQL Server replacement at home.
- MSDE as database. You can also use MS SQL Server 2005 Express Edition if you have .Net Framework 2.0 installed.
- MSDE Query Tool as SQL Query Analyzer.
- Or SQLBuddy as SQL Query Analyzer.
- Or Server Explorer view of Visual Studio.Net and SqlPrompt for SQL intellisense.