Yahoo Web Search

Search results

1. Top results related to how to initialize a dictionary in c# with sql

   • How to connect a C# console application with a database stored in a .sql file

     Top Answer

     Answered Mar 13, 2012 · 1 votes

     It sounds like you have NHibernate setup and you need to know how to get data out of it, into your application.

     This tutorial has everything you need:

     http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-application.aspx

     Check all answers on Stack Overflow

     1/5

   • How to get a parameter output from SQL Server with C# and put the value in a session variable

     Top Answer

     Answered May 26, 2020 · 1 votes

     Hi I can only post code here and this would be the way I wrote it (couldn't test it):

     I assume your default db schema is dbo => dbo.obtenerROl.

     public void obtenerRol() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connDb"].ConnectionString)) using (SqlCommand cmd = new SqlCommand("dbo.obtenerROl", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@user", SqlDbType.VarChar).Value = txtUsuario.Text.Trim(); cmd.Parameters.Add("@passwrd ", SqlDbType.VarChar).Value = txtContraseña.Text.Trim(); SqlParameter rol = new SqlParameter("@rol", SqlDbType.TinyInt); rol.Direction = ParameterDirection.Output; cmd.Parameters.Add(rol); conn.Open(); cmd.ExecuteNonQuery(); //according to https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/sql-clr-type-mapping byte userRole = (byte) cmd.Parameters["@rol"].Value; Session["UserRole"] = userRole; conn.Close(); } }

     and

     CREATE PROCEDURE obtenerROl @user varchar(20), @passwrd varchar(20), @rol tinyint OUTPUTASBEGIN SELECT @rol = idROl FROM Users WHERE nameUSer = @user AND password = @passwrd RETURN 0; -- for successEND

     you could also

     CREATE PROCEDURE obtenerROl @user varchar(20), @passwrd varchar(20)ASBEGIN DECLARE @rol tinyint = 0; -- default role SELECT @rol = idROl FROM Users WHERE nameUSer = @user AND password = @passwrd; SELECT @rol;END

     and your C# Code: ExecuteScalar will get the @rol.

     public void obtenerRol(){ using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connDb"].ConnectionString)) using (SqlCommand cmd = new SqlCommand("dbo.obtenerROl", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@user", SqlDbType.VarChar).Value = txtUsuario.Text.Trim(); cmd.Parameters.Add("@passwrd ", SqlDbType.VarChar).Value = txtContraseña.Text.Trim(); conn.Open(); var value = cmd.ExecuteScalar(); //according to https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/sql-clr-type-mapping byte userRole = (byte)value; Session["UserRole"] = userRole; conn.Close(); }}

     To be complete:

     • sanitize user inputs (txtUsuario/txtContrasena - are maybe TextInputFields?) to prevent SQL Injectiopns MSDN: SQL Injection
     • never save passwords cleartext in db SO: Some Best Practices for userdata

     Check all answers on Stack Overflow

     2/5

   • How to log changes to database every 5 minutes in a high-transaction application with C# and SQL?

     Top Answer

     Answered May 07, 2011 · 3 votes

     Deffered update is the key, indeed, and you are on the right path with your local cache approach. As long as you don't have a requirement to display the last-update-count on each visit, the solution is simple: update a local cache of account_id->count and periodically sweep through this cache, replace the count with 0 and add the count to the total in the database. You may loose some visit counts if your ASP.Net process is lost, and your display hit count is not accurate (Node 1 int he ASP farm returns it's lats count, Node 2 returns its own local one, different from Node 1).

     If you must have accurate display of counts on each return result (whether this is an page return or a service return, matter little) then it gets hairy quite fast. Centralized cache like Memcache can help to create a solution, but is not trivial.

     Here is how I would keep the local cache:

     class HitCountCache{ class Counter { public unsigned int count {get;set} public accountid {get;set} }; private Dictionary<accountType, Counter> _counts = new Dictionary<...>(); private Object _lock= new Object(); // invoke this on every call // void IncrementAccountId (accountId) { Counter count; lock(_lock) { if (_counts.TryGetValue (accountId, out count)) { ++count.count; } else { _counts.Add (accountId, new Counter {accountId = accountId; count=0}); } } } // Schedule this to be invoked every X minutes // void Save (SqlConnection conn) { Counter[] counts; // Snap the counts, under lock // lock(_lock) { counts = _counts.ToArray(); _counts.Clear(); } // Lock is released, can do DB work // foreach(Counter c in counts) { SqlCommand cmd = new SqlCommand( @"Update table set count+=@count where accountId=@accountId", conn); cmd.Parameters.AddWithValue("@count", c.count); cmd.Parameters.AddWithValue("@accountId", accountId); cmd.ExecuteNoQuery(); } } }

     This is a skeleton, it can be improved, and can also be made to return the current total count if needed, at least the total count as known by local node.

     Check all answers on Stack Overflow

     3/5

   • How to dispose a SQL connection in c# in a best way?

     Top Answer

     Answered Jul 16, 2017 · 5 votes

     The using will take care of it for you. Under the hood, SqlConnection.Dispose() calls the SqlConnection.Close() method, and SqlCommand.Dispose() calls SqlCommand.Close().

     As additional background, a using statement is syntactic sugar for a try ... finally that disposes the IDisposable object in the finally.

     Check all answers on Stack Overflow

     4/5

   • How to put objects into a dictionary using Dapper in C#?

     Top Answer

     Answered Jun 08, 2015 · 4 votes

     public class SP { public string RoutineName { get; set; } public DateTime Created { get; set; } public DateTime Modified { get; set; }}-

     Dictionary<string, SP> dictionary = connection.Query<SP>(@" SELECT routine_name AS RoutineName, created AS Created, modified AS Modified FROM PROCEDURES").ToDictionary(m => m.RoutineName, m => m);

     • Create proper model public class SP { public string RoutineName { get; set; } public DateTime Created { get; set; } public DateTime Modified { get; set; }}
     • Map your query to model properties, select it to dictionary Dictionary<string, SP> dictionary = connection.Query<SP>(@" SELECT routine_name AS RoutineName, created AS Created, modified AS Modified FROM PROCEDURES").ToDictionary(m => m.RoutineName, m => m);

     Check all answers on Stack Overflow

     5/5

   Show moreShow less

2. stackoverflow.com › questions › 17047602Proper way to initialize a C# dictionary with values

   stackoverflow.com › questions › 17047602

   • Cached

   Suppose we have a dictionary like this: Dictionary<int, string> dict = new Dictionary<int, string>(); dict.Add(1, "Mohan"); dict.Add(2, "Kishor"); dict.Add(3, "Pankaj"); dict.Add(4, "Jeetu"); We can initialize it as follows. Dictionary<int, string> dict = new Dictionary<int, string>. {.

   Code sample

   var myDict = new Dictionary<string, string> {

     { "key1", "value1" },

     { "key2", "value2" }

   };

   Console.ReadKey();...

   See more on stackoverflow

3. learn.microsoft.com › en-us › dotnetHow to initialize a dictionary with a collection initializer - C#

   learn.microsoft.com › en-us › dotnet

   • Cached

   • Overview
   • Example
   • See also

   A Dictionary contains a collection of key/value pairs. Its Add method takes two parameters, one for the key and one for the value. One way to initialize a Dictionary , or any collection whose Add method takes multiple parameters, is to enclose each set of parameters in braces as shown in the following example. Another optio...

   See full list on learn.microsoft.com

   In the following code example, a Dictionary is initialized with instances of type StudentName. The first initialization uses the Add method with two arguments. The compiler generates a call to Add for each of the pairs of int keys and StudentName values. The second uses a public read / write indexer method of the Dictionary class:

   Note the two pairs of braces in each element of the collection in the first declaration. The innermost braces enclose the object initializer for the StudentName, and the outermost braces enclose the initializer for the key/value pair that will be added to the students Dictionary . Finally, the whole collection initializer for the dictionary is enclosed in braces. In the second initialization, the left side of the assignment is the key and the right side is the value, using an object initializer for StudentName.

   See full list on learn.microsoft.com

   •C# Programming Guide

   •Object and Collection Initializers

   See full list on learn.microsoft.com

4. People also ask

   How to initialize a dictionary with values?

   • You can declare a dictionary and initialize it with values by using the collection initializer syntax. Within the initializer block, you have two options for adding key/value pairs to the dictionary: Indexer syntax, like [key] = value. Curly brace syntax, like { key, value }. I’ll show examples of both options below.

   C# - Initialize a dictionary | MAKOLYTE

   makolyte.com/csharp-initialize-a-dictionary/

   See all results for this question

   How to initialize a dictionary in C#?

   • In the second initialization, the left side of the assignment is the key and the right side is the value, using an object initializer for StudentName. Learn how to initialize a dictionary in C#, using either the Add method or an index initializer. This example shows both options.

   How to initialize a dictionary with a collection initializer - C#

   learn.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/how-to-initialize-a-dictionary-with-a-collection-initializer

   See all results for this question

   How can I initialize a dictionary in one line?

   • How can I do it in one line? Defining values of the object with the constructor is called an object initializer. For collections (like dictionary), it is called a collection initializer. Please, read How to: Initialize a Dictionary with a Collection Initializer (C# Programming Guide)

   c# - One-liner to create a dictionary with one entry - Stack Overflow

   stackoverflow.com/questions/14454929/one-liner-to-create-a-dictionary-with-one-entry

   See all results for this question

   How to initialize a dictionary with key-value pairs?

   • Besides creating an empty dictionary, we can also initialize a dictionary with some key-value pairs at the time of creation. Consider the following example: { "apple", 1 }, { "banana", 2 }, { "cherry", 3 } In this code snippet, we have created a dictionary, "dict", and initialized it with three key-value pairs.

   Guide to Initialize a Dictionary in C# | C# Tutorial

   www.gyata.ai/c-sharp/c-initialize-dictionary/

   See all results for this question

5. stackoverflow.com › questions › 62474499.net - Initialize dictionary with value (C#) - Stack Overflow

   stackoverflow.com › questions › 62474499

   • Cached

   Initialize dictionary with value (C#) Asked 3 years, 11 months ago. Modified 3 years, 11 months ago. Viewed 2k times. 0. I have model with Dictionary, that I want to initialize with default value Here is how I do it now. public Dictionary<string, string> controllableProperties = new Dictionary<string, string> {

6. makolyte.com › csharp-initialize-a-dictionaryC# - Initialize a dictionary | makolyte

   makolyte.com › csharp-initialize-a-dictionary

   • Cached

   Sep 12, 2023 · Option 1 – Initialize dictionary with values using indexer syntax. Here’s an example of initializing a dictionary with multiple key/value pairs using the indexer syntax (i.e. [key]=value): using System.Collections.Generic; var dictionary = new Dictionary< string, int >() { ["Bob"] = 1, ["Linda"] = 2, ["Teddy"] = 3}; Code language: C# (cs)

7. www.gyata.ai › c-sharp › c-initialize-dictionaryGuide to Initialize a Dictionary in C# | C# Tutorial

   www.gyata.ai › c-sharp › c-initialize-dictionary

   • Cached

   Dec 8, 2023 · Table of Contents. 1. Initializing an Empty Dictionary. 2. Initializing a Dictionary with Key-Value Pairs. 3. Initializing a Dictionary from an Array, List, or Other Enumerable. 4. Tips, Tricks, and Common Pitfalls. 4.1 Duplicate Keys. 4.2 Null Keys. 4.3 Key Not Found. 5. Conclusion.

8. www.techiedelight.com › initialize-dictionary-csharpInitialize a Dictionary in C# | Techie Delight

   www.techiedelight.com › initialize-dictionary-csharp

   • Cached

   Apr 6, 2024 · 1. Collection Initializer. To initialize a dictionary, we can enclose each set of key-value in curly braces. Internally for each pair, the compiler makes a call to Dictionary’s Add() method. This is demonstrated below: Download Run Code. 2. Index Initializer. We can also initialize a dictionary using an index initializer, as shown below.

9. www.tutorialsteacher.com › csharp › csharp-dictionaryC# Dictionary - TutorialsTeacher.com

   www.tutorialsteacher.com › csharp › csharp-dictionary

   • Cached

   The following example shows how to create a dictionary and add key-value pairs. Example: Create Dictionary and Add Elements IDictionary < int , string > numberNames = new Dictionary < int , string >(); numberNames.Add(1, "One" ); //adding a key/value using the Add() method numberNames.Add(2, "Two" ); numberNames.Add(3, "Three" ); //The ...