Coding Tricks

This blog is all about sharing tricks, tips, and information about technology, designing, coding and programming languages.

Search This Blog

Home
HTML
JavaScript
SEO
C#
.NET

Showing posts with the label SSMS

View all

Posts

How to change SELECT Top 1000 rows or EDIT Top 200 rows Default Values in SQL Server Management Studio?

mssql SSMS

+

0

Get link
Facebook
X
Pinterest
Email
Other Apps

Change blog language

Calculate similarity between two strings in C#

This article explains how you can calculate similarity between two strings in C# in percentage or score from 0 to 1. Basically, to compare two strings in C# we use the compare or equals method but when we want to match string similarity in percentage or in a score like from 0 to 1 then these methods are not helpful so you can use following manual methods to achieve this. Here is logic to check the similarity between two strings, just copy & paste this into your code editor and run to test. Main method : // Compares the two strings based on letter pair matches public static double CompareStrings(string str1, string str2) { List pairs1 = WordLetterPairs(str1.ToUpper()); List pairs2 = WordLetterPairs(str2.ToUpper()); int intersection = 0; int union = pairs1.Count + pairs2.Count; for (int i = 0; i < pairs1.Count; i++) { for (int j = 0; j < pairs2.Count; j++) { ...

How to create edmx file in visual studio | Create edmx file with entity framework

In this article, we are going to learn how we can add edmx data model file to .net framework or class library project in visual studio. What is Edmx? .edmx is basically an XML file which is generated when we add Entity Framework model. It is Entity Data Model Xml which contains designer (Model) and code file(.cs). Step 1: Right click on proj and select add new item Right click on your project and select add > new item option. Step 2: Select ADO.NET entity data model option Go to data and select ADO.NET entity data model type, and then give name to your edmx file and click on add. Step 3: Select model option Select 'EF designers from database' option from next window, and click on next. Step 4: Click on new connection option In next window click on new connection button to establish database connection Step 5: Establish database connection Select all required option and then click on test connection button to check your database connection valid or not. If you are connecti...

Powered by Blogger

Copyright by @CodingTricks