Click here to Skip to main content
15,882,017 members

Articles by DiponRoy (Articles: 26, Tip/Tricks: 51)

Articles: 26, Tip/Tricks: 51

RSS Feed

Average article rating: 4.49

Database Development
28 Jul 2014   Updated: 28 Jul 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 17,933     Bookmarked: 16   Downloaded: 40
Please Sign up or sign in to vote.
How to manage Entity Framework Code First in Real Time Projects
13 Aug 2014   Updated: 13 Aug 2014   Rating: 4.36/5    Votes: 12   Popularity: 4.70
Licence: CPOL    Views: 61,981     Bookmarked: 16   Downloaded: 504
Please Sign up or sign in to vote.
Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First
3 Jul 2022   Updated: 3 Jul 2022   Rating: 1.67/5    Votes: 3   Popularity: 0.80
Licence: CPOL    Views: 15,408     Bookmarked: 2   Downloaded: 47
Please Sign up or sign in to vote.
Conditional filter query example in SQLAlchemy and Python
5 Jul 2022   Updated: 5 Jul 2022   Rating: 4.27/5    Votes: 5   Popularity: 2.99
Licence: CPOL    Views: 12,041     Bookmarked: 7   Downloaded: 129
Please Sign up or sign in to vote.
Example of Generic Repository Class with SQLAlchemy and Python
PostgreSQL
27 May 2019   Updated: 27 May 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 7,973     Bookmarked: 4   Downloaded: 86
Please Sign up or sign in to vote.
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
28 Jun 2022   Updated: 28 Jun 2022   Rating: 4.20/5    Votes: 3   Popularity: 2.00
Licence: CPOL    Views: 5,670     Bookmarked: 10   Downloaded: 83
Please Sign up or sign in to vote.
How to use MERGE statements in different databases
SQL Server
15 Jul 2019   Updated: 15 Jul 2019   Rating: 4.68/5    Votes: 7   Popularity: 3.96
Licence: CPOL    Views: 10,096     Bookmarked: 20   Downloaded: 217
Please Sign up or sign in to vote.
Conditinal filter query example in SQL, Lambda Expression, C#
15 Sep 2014   Updated: 15 Sep 2014   Rating: 4.86/5    Votes: 49   Popularity: 8.08
Licence: CPOL    Views: 506,650     Bookmarked: 64   Downloaded: 2,216
Please Sign up or sign in to vote.
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
18 Aug 2014   Updated: 18 Aug 2014   Rating: 4.96/5    Votes: 15   Popularity: 5.53
Licence: CPOL    Views: 25,300     Bookmarked: 15   Downloaded: 129
Please Sign up or sign in to vote.
Here, we will see the basic differences or similarities between various joins of MS SQL Server.
4 Mar 2015   Updated: 4 Mar 2015   Rating: 4.83/5    Votes: 5   Popularity: 3.38
Licence: CPOL    Views: 20,143     Bookmarked: 7   Downloaded: 127
Please Sign up or sign in to vote.
Table Hierarchy or Generation Finder For Relational Database In SQL Server
2 Jul 2019   Updated: 2 Jul 2019   Rating: 4.55/5    Votes: 8   Popularity: 4.10
Licence: CPOL    Views: 13,945     Bookmarked: 14   Downloaded: 147
Please Sign up or sign in to vote.
Creating CLR in SQL Server
11 Jul 2019   Updated: 11 Jul 2019   Rating: 3.59/5    Votes: 8   Popularity: 3.24
Licence: CPOL    Views: 9,061     Bookmarked: 17   Downloaded: 134
Please Sign up or sign in to vote.
Populating DateTime range in SQL Server
11 Apr 2020   Updated: 11 Apr 2020   Rating: 4.39/5    Votes: 6   Popularity: 3.42
Licence: CPOL    Views: 41,281     Bookmarked: 9   Downloaded: 933
Please Sign up or sign in to vote.
Store all data change history in a table using Entity Framework Core
3 Aug 2022   Updated: 3 Aug 2022   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 9,872     Bookmarked: 3   Downloaded: 53
Please Sign up or sign in to vote.
Options to customize EF Core migration table
9 Aug 2022   Updated: 9 Aug 2022   Rating: 4.64/5    Votes: 11   Popularity: 4.64
Licence: CPOL    Views: 70,392     Bookmarked: 19   Downloaded: 434
Please Sign up or sign in to vote.
Run Raw SQL Query - Entity Framework Core 6
DevOps
Unit Testing
15 Aug 2022   Updated: 15 Aug 2022   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 20,727     Bookmarked: 7   Downloaded: 53
Please Sign up or sign in to vote.
How to delete all rows in EF Core 6 using alternate options
Programming Languages
Basic
2 Aug 2020   Updated: 2 Aug 2020   Rating: 4.27/5    Votes: 5   Popularity: 2.99
Licence: CPOL    Views: 18,013     Bookmarked: 4   Downloaded: 424
Please Sign up or sign in to vote.
Read a large CSV or any character separated values file chunk by chunk as DataTable and Entity List
C#
13 Jul 2014   Updated: 13 Jul 2014   Rating: 4.83/5    Votes: 11   Popularity: 4.83
Licence: CPOL    Views: 57,789     Bookmarked: 16   Downloaded: 465
Please Sign up or sign in to vote.
Log all the parameters passed to some method in C#
7 Jun 2014   Updated: 7 Jun 2014   Rating: 5.00/5    Votes: 10   Popularity: 4.52
Licence: CPOL    Views: 41,730     Bookmarked: 14   Downloaded: 154
Please Sign up or sign in to vote.
Enum with text value in C#
9 Jun 2014   Updated: 9 Jun 2014   Rating: 4.88/5    Votes: 34   Popularity: 7.42
Licence: CPOL    Views: 142,128     Bookmarked: 49   Downloaded: 2,435
Please Sign up or sign in to vote.
Conversion between DataTable and List in C#
17 Jun 2019   Updated: 17 Jun 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 18,577     Bookmarked: 9   Downloaded: 150
Please Sign up or sign in to vote.
Range model class to manage range related operations for a specific data type
29 Jul 2022   Updated: 29 Jul 2022   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 41,357     Bookmarked: 7   Downloaded: 598
Please Sign up or sign in to vote.
Generate and store logs using middleware
Web Development
ASP.NET
30 Jul 2020   Updated: 30 Jul 2020   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 29,017     Bookmarked: 10   Downloaded: 1,569
Please Sign up or sign in to vote.
Making schedule jobs exe using Quartz scheduler
5 Apr 2020   Updated: 5 Apr 2020   Rating: 4.89/5    Votes: 7   Popularity: 4.14
Licence: CPOL    Views: 41,337     Bookmarked: 9   Downloaded: 330
Please Sign up or sign in to vote.
Select data as DataTable object for a database using Entity Framework
HTML
24 Jul 2014   Updated: 24 Jul 2014   Rating: 4.67/5    Votes: 35   Popularity: 7.15
Licence: CPOL    Views: 263,250     Bookmarked: 53   Downloaded: 6,832
Please Sign up or sign in to vote.
Do GET, POST, PUT, DELETE in ASP.NET MVC with Jquery Ajax
16 Jul 2014   Updated: 16 Jul 2014   Rating: 4.50/5    Votes: 11   Popularity: 4.50
Licence: CPOL    Views: 28,812     Bookmarked: 23   Downloaded: 395
Please Sign up or sign in to vote.
Exception log with request detail in ASP.NET MVC

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.42

Containers
Docker
6 Jul 2022   Updated: 6 Jul 2022   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 16,954     Bookmarked: 14   Downloaded: 148
Please Sign up or sign in to vote.
Quick start example to run DB and clients in docker
17 Jul 2022   Updated: 17 Jul 2022   Rating: 3.00/5    Votes: 3   Popularity: 1.43
Licence: CPOL    Views: 8,832     Bookmarked: 6   Downloaded: 63
Please Sign up or sign in to vote.
How to run FTP, SFTP, SMTP, Cache, LDAP, SSO and other servers in Docker
Database Development
19 May 2019   Updated: 19 May 2019   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 13,113     Bookmarked: 5   Downloaded: 72
Please Sign up or sign in to vote.
The aim of this helper class is to divide a large IEnumerable into multiple small list.
PostgreSQL
21 Jul 2019   Updated: 21 Jul 2019   Rating: 4.63/5    Votes: 4   Popularity: 2.78
Licence: CPOL    Views: 9,231     Bookmarked: 1   Downloaded: 41
Please Sign up or sign in to vote.
Select a default row for a query that returns no rows
SQL Server
14 Feb 2019   Updated: 14 Feb 2019   Rating: 4.67/5    Votes: 3   Popularity: 2.23
Licence: CPOL    Views: 32,778     Bookmarked: 9   Downloaded: 114
Please Sign up or sign in to vote.
A utility class to send parameters for IN() operator in SQL using parameterized queries
10 Jul 2019   Updated: 10 Jul 2019   Rating: 3.68/5    Votes: 7   Popularity: 3.11
Licence: CPOL    Views: 62,088     Bookmarked: 13   Downloaded: 99
Please Sign up or sign in to vote.
Finding week start and end date time from a given date time
30 Jul 2014   Updated: 30 Jul 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 19,590     Bookmarked: 7   Downloaded: 98
Please Sign up or sign in to vote.
How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first
19 Feb 2019   Updated: 19 Feb 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 24,851     Bookmarked: 7   Downloaded: 57
Please Sign up or sign in to vote.
How to do string split and join in SQL Server
29 May 2019   Updated: 29 May 2019   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 6,343     Bookmarked: 3   Downloaded: 77
Please Sign up or sign in to vote.
A utility query to find table generations in SQL Server relational database
5 Jul 2022   Updated: 5 Jul 2022   Rating: 3.91/5    Votes: 8   Popularity: 3.53
Licence: CPOL    Views: 4,340     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Using CASE with variable/SET, SELECT/UPDATE statement, WHERE clause, JOIN & ON clause
1 Jul 2023   Updated: 1 Jul 2023   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 8,311     Bookmarked: 2   Downloaded: 18
Please Sign up or sign in to vote.
Split date time ranges into days or possibly other ranges using CTE in SQL Server
Desktop Programming
8 Feb 2019   Updated: 8 Feb 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 14,838     Bookmarked: 1   Downloaded: 200
Please Sign up or sign in to vote.
Limit number of lines in a RichTextBox
DevOps
Load Testing
11 Jun 2014   Updated: 11 Jun 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 16,070     Bookmarked: 9   Downloaded: 99
Please Sign up or sign in to vote.
Custom Seed Serializer for Entity Framework Code First C#
General Programming
String
26 Jun 2019   Updated: 26 Jun 2019   Rating: 4.75/5    Votes: 4   Popularity: 2.86
Licence: CPOL    Views: 21,832     Bookmarked: 17   Downloaded: 216
Please Sign up or sign in to vote.
Create hash and compare
Productivity Apps and Services
Microsoft Office
5 Apr 2020   Updated: 5 Apr 2020   Rating: 3.19/5    Votes: 5   Popularity: 2.23
Licence: CPOL    Views: 25,931     Bookmarked: 20   Downloaded: 719
Please Sign up or sign in to vote.
Create a file like Excel, CSV, txt, etc. from a DataTable object using C#
Programming Languages
C#
5 Jun 2020   Updated: 5 Jun 2020   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 8,974     Bookmarked: 0   Downloaded: 90
Please Sign up or sign in to vote.
Use same EDMX file with different Oracle database schemas
2 Sep 2014   Updated: 2 Sep 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 52,133     Bookmarked: 16   Downloaded: 386
Please Sign up or sign in to vote.
Let’s see how to make a simple model or Entity mapper using reflections in C#
19 May 2019   Updated: 19 May 2019   Rating: 4.64/5    Votes: 4   Popularity: 2.79
Licence: CPOL    Views: 22,577     Bookmarked: 7   Downloaded: 310
Please Sign up or sign in to vote.
The aim of this helper class is to divide a large datatable into multiple small datatables.
10 Sep 2014   Updated: 10 Sep 2014   Rating: 4.92/5    Votes: 11   Popularity: 5.13
Licence: CPOL    Views: 48,395     Bookmarked: 21   Downloaded: 232
Please Sign up or sign in to vote.
Let's make a lambda expression from a property name of a particular entity, and use it for OrderBy shorting
31 Jul 2019   Updated: 31 Jul 2019   Rating: 2.64/5    Votes: 4   Popularity: 1.59
Licence: CPOL    Views: 7,362     Bookmarked: 3   Downloaded: 88
Please Sign up or sign in to vote.
Calling an API which has a limit of calls per second
2 Jun 2019   Updated: 2 Jun 2019   Rating: 4.80/5    Votes: 7   Popularity: 4.06
Licence: CPOL    Views: 13,982     Bookmarked: 6   Downloaded: 67
Please Sign up or sign in to vote.
Utility class and model to manage range related operations
7 Aug 2022   Updated: 7 Aug 2022   Rating: 3.40/5    Votes: 2   Popularity: 1.02
Licence: CPOL    Views: 7,501     Bookmarked: 5   Downloaded: 40
Please Sign up or sign in to vote.
EF Core first publishing multiple DB contexts in same DB
Javascript
28 May 2014   Updated: 28 May 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 13,942     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
This is a simple inheritance example in JavaScript
8 Jul 2014   Updated: 10 Jul 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 11,460     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to change the functionality or behavior of a function in JavaScript
Python
7 Jul 2022   Updated: 7 Jul 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 12,074     Bookmarked: 5   Downloaded: 41
Please Sign up or sign in to vote.
This example is to partially update data in FastAPI using SQLAlchemy and Python
SQL
23 Sep 2014   Updated: 23 Sep 2014   Rating: 4.73/5    Votes: 12   Popularity: 5.10
Licence: CPOL    Views: 82,660     Bookmarked: 12   Downloaded: 288
Please Sign up or sign in to vote.
Here we will see how to use PIVOT and JOIN together in SQL query
18 Feb 2019   Updated: 18 Feb 2019   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 28,470     Bookmarked: 9   Downloaded: 90
Please Sign up or sign in to vote.
Selecting single row from a group of rows
Security
Identity
4 Jul 2022   Updated: 4 Jul 2022   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 6,480     Bookmarked: 3   Downloaded: 26
Please Sign up or sign in to vote.
How to auto increment column options in databases
Web Development
ASP.NET
8 Feb 2019   Updated: 8 Feb 2019   Rating: 4.89/5    Votes: 2   Popularity: 1.47
Licence: CPOL    Views: 14,646     Bookmarked: 1   Downloaded: 60
Please Sign up or sign in to vote.
Configure JSON serialization settings
13 Jul 2020   Updated: 13 Jul 2020   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 37,635     Bookmarked: 11   Downloaded: 962
Please Sign up or sign in to vote.
Using SFTP/FTP in ASP.NET CORE projects
15 Jul 2020   Updated: 15 Jul 2020   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 34,634     Bookmarked: 12   Downloaded: 670
Please Sign up or sign in to vote.
Username and password validation process from LDAP server in ASP.NET and ASP.NET Core
20 Jul 2020   Updated: 20 Jul 2020   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 11,964     Bookmarked: 6   Downloaded: 325
Please Sign up or sign in to vote.
Using SFTP/FTP in ASP.NET projects
6 Jul 2014   Updated: 6 Jul 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 30,565     Bookmarked: 17   Downloaded: 361
Please Sign up or sign in to vote.
Session Manager Utility for ASP.NET
13 Jul 2020   Updated: 13 Jul 2020   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 72,366     Bookmarked: 7   Downloaded: 571
Please Sign up or sign in to vote.
Deploy Web API and Angular from the same project to the same IIS port
14 Jun 2020   Updated: 14 Jun 2020   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 7,903     Bookmarked: 1   Downloaded: 156
Please Sign up or sign in to vote.
Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.
28 Dec 2021   Updated: 28 Dec 2021   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: CPOL    Views: 34,457     Bookmarked: 3   Downloaded: 26
Please Sign up or sign in to vote.
Delete all the records from the table using EF
18 Jul 2022   Updated: 18 Jul 2022   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 9,713     Bookmarked: 11   Downloaded: 86
Please Sign up or sign in to vote.
Add execution time as a response header in ASP.NET Core
22 Jul 2022   Updated: 22 Jul 2022   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 13,935     Bookmarked: 8   Downloaded: 44
Please Sign up or sign in to vote.
Set a generated unique id to HttpContext.TraceIdentifier using middleware
26 Jul 2022   Updated: 26 Jul 2022   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 53,555     Bookmarked: 14   Downloaded: 206
Please Sign up or sign in to vote.
Conversion of complex object to a list of objects
HTML
27 Jun 2014   Updated: 27 Jun 2014   Rating: 4.78/5    Votes: 28   Popularity: 6.76
Licence: CPOL    Views: 180,156     Bookmarked: 30   Downloaded: 2,856
Please Sign up or sign in to vote.
Session in ASP.NET MVC
13 Jul 2014   Updated: 13 Jul 2014   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 28,083     Bookmarked: 8   Downloaded: 219
Please Sign up or sign in to vote.
Knockout Validation Error Message & Bootstrap v3.2 input-group
16 Jul 2014   Updated: 16 Jul 2014   Rating: 4.20/5    Votes: 2   Popularity: 1.26
Licence: CPOL    Views: 28,916     Bookmarked: 3   Downloaded: 34
Please Sign up or sign in to vote.
Using $index in Knockout.js
30 May 2014   Updated: 30 May 2014   Rating: 4.82/5    Votes: 5   Popularity: 3.37
Licence: CPOL    Views: 53,695     Bookmarked: 8   Downloaded: 1,217
Please Sign up or sign in to vote.
Bootstrap datepicker and Knockout Model Binding
1 Jun 2014   Updated: 12 Jun 2014   Rating: 4.86/5    Votes: 4   Popularity: 2.92
Licence: CPOL    Views: 22,910     Bookmarked: 3   Downloaded: 39
Please Sign up or sign in to vote.
Trimmed value binding in knockout.js
3 Jul 2014   Updated: 3 Jul 2014   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 15,961     Bookmarked: 6   Downloaded: 126
Please Sign up or sign in to vote.
How to use Ajax validation in Knockout
4 Jul 2014   Updated: 4 Jul 2014   Rating: 4.64/5    Votes: 4   Popularity: 2.79
Licence: CPOL    Views: 16,705     Bookmarked: 6   Downloaded: 112
Please Sign up or sign in to vote.
Using Observable and Computed for validation in Knockout
21 Jul 2014   Updated: 22 Jul 2014   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 10,380     Bookmarked: 3   Downloaded: 41
Please Sign up or sign in to vote.
How to post rowversion or timestamp of MsSQL using jquery
11 Jul 2014   Updated: 11 Jul 2014   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 26,217     Bookmarked: 3   Downloaded: 58
Please Sign up or sign in to vote.
How to use trimming during object to JSON string serialization in JavaScript
13 Jul 2014   Updated: 13 Jul 2014   Rating: 4.22/5    Votes: 7   Popularity: 3.57
Licence: CPOL    Views: 15,501     Bookmarked: 8   Downloaded: 77
Please Sign up or sign in to vote.
Simple response object for ASP.NET
HTML5
15 Jun 2014   Updated: 15 Jun 2014   Rating: 4.67/5    Votes: 2   Popularity: 1.40
Licence: CPOL    Views: 34,464     Bookmarked: 8   Downloaded: 320
Please Sign up or sign in to vote.
Knockout Data-binding to Table with rowspan
IIS
29 Jan 2015   Updated: 29 Jan 2015   Rating: 4.93/5    Votes: 6   Popularity: 3.84
Licence: CPOL    Views: 99,043     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
How to restore IIS setups to its default, without uninstalling or repairing Windows

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Bangladesh Bangladesh
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.