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. stackoverflow.com › questions › 10998961c# - Adding values to a dictionary via inline initialization ...

   stackoverflow.com › questions › 10998961

   • Cached

   Mar 10, 2017 · var numbers = new Dictionary<int, string> { [7] = "seven", [9] = "nine", [13] = "thirteen" }; The preceding sample generates code that calls the Item[TKey] to set the values. Before C# 6, you could initialize dictionaries and other associative containers using the following syntax.

4. People also ask

   How to initialize a dictionary?

   • 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: 2. Index Initializer We can also initialize a dictionary using an index initializer, as shown below.

   Initialize a Dictionary in C# | Techie Delight

   www.techiedelight.com/initialize-dictionary-csharp/

   See all results for this question

   How do I create a dictionary in C#?

   • With C# 6.0, you can create a dictionary in the following way: ["one"] = 1, ["two"] = 2, ["three"] = 3 It even works with custom types. That's a new syntax I wasn't familiar with. Thanks. I didn't know this syntax, thanks. It makes it easy to copy and paste dictionaries of data from other languages such as Lua.

   Proper way to initialize a C# dictionary with values

   stackoverflow.com/questions/17047602/proper-way-to-initialize-a-c-sharp-dictionary-with-values

   See all results for this question

   How to initialize a dictionary TKey TValue?

   • 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.

   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

   Will a 'add' method create a new dictionary?

   • This is using initializer syntax to invoke the .Add method. This will overwrite the value added in the constructor, just as the last code block provided by the asker will. No it won't. It will add to the existing dictionary. It will not create a new one. ... You got me, I didn't try it. Give me a second. If you're right I will humbly apologise.

   c# - Adding values to a dictionary via inline initialization of its

   stackoverflow.com/questions/10998961/adding-values-to-a-dictionary-via-inline-initialization-of-its-container

   See all results for this question

5. 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

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.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.

8. amarozka.dev › dictionary-data-structure-in-csharpEfficient Data Management with Dictionary in C# - .Net Code ...

   amarozka.dev › dictionary-data-structure-in-csharp

   • Cached

   Aug 16, 2023 · 1. Creating a Dictionary: Dictionary<string, int> ageDictionary = new Dictionary<string, int>(); In this example, a new dictionary named ` ageDictionary ` is created to store pairs where keys are strings (representing names) and values are integers (representing ages). 2. Adding and Retrieving Elements: ageDictionary.Add("Alice", 25);

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

   www.tutorialsteacher.com › csharp › csharp-dictionary

   • Cached

   . //creating a dictionary using collection-initializer syntax var cities = new Dictionary<string, string>(){ {"UK", "London, Manchester, Birmingham"}, {"USA", "Chicago, New York, Washington"}, {"India", "Mumbai, New Delhi, Pune"} }; . foreach(var kvp in cities) Console.WriteLine("Key: {0}, Value: {1}", kvp.Key, kvp.Value); Try it.