Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string query = @"SELECT SUM(CAST(ConcurrentUsers AS INT)) FROM [website].[db]
- WHERE(ConcurrencyLicensing NOT LIKE 0)";
- SqlConnection conn = new SqlConnection(entityBuilder.ProviderConnectionString);
- SqlCommand cmd = new SqlCommand(query, conn);
- try
- {
- conn.Open();
- object userNameObj = cmd.ExecuteScalar();
- if(userNameObj != null)
- {
- int getUserName = (int)userNameObj;
- return getUserName;
- }
- else
- {
- return 0;
- }
- }
- finally
- {
- conn.Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement