Click here to Skip to main content
15,566,615 members

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

Articles: 26, Tip/Tricks: 50

RSS Feed

Average article rating: 4.45

Database Development
29 Jul 2014   Updated: 29 Jul 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 16,172     Bookmarked: 15   Downloaded: 35
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: 56,746     Bookmarked: 16   Downloaded: 501
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.00/5    Votes: 2   Popularity: 0.30
Licence: CPOL    Views: 6,323     Bookmarked: 2   Downloaded: 34
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: 5,140     Bookmarked: 6   Downloaded: 64
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: 6,293     Bookmarked: 4   Downloaded: 82
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: 4,180     Bookmarked: 8   Downloaded: 75
Please Sign up or sign in to vote.
How to use MERGE statements in different databases
SQL Server
11 Apr 2020   Updated: 11 Apr 2020   Rating: 4.39/5    Votes: 6   Popularity: 3.42
Licence: CPOL    Views: 35,056     Bookmarked: 9   Downloaded: 792
Please Sign up or sign in to vote.
Store all data change history in a table using Entity Framework Core
15 Jul 2019   Updated: 15 Jul 2019   Rating: 4.68/5    Votes: 7   Popularity: 3.96
Licence: CPOL    Views: 8,855     Bookmarked: 20   Downloaded: 211
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: 477,831     Bookmarked: 64   Downloaded: 2,187
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: 22,500     Bookmarked: 14   Downloaded: 127
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: 18,653     Bookmarked: 7   Downloaded: 121
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: 11,604     Bookmarked: 14   Downloaded: 146
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: 7,641     Bookmarked: 17   Downloaded: 133
Please Sign up or sign in to vote.
Populating DateTime range in SQL Server
3 Aug 2022   Updated: 3 Aug 2022   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 3,861     Bookmarked: 3   Downloaded: 33
Please Sign up or sign in to vote.
Options to customize EF Core migration table
9 Aug 2022   Updated: 9 Aug 2022   Rating: 4.34/5    Votes: 8   Popularity: 3.92
Licence: CPOL    Views: 17,744     Bookmarked: 16   Downloaded: 190
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: 6,970     Bookmarked: 6   Downloaded: 43
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: 14,173     Bookmarked: 4   Downloaded: 371
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: 54,228     Bookmarked: 16   Downloaded: 458
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: 38,990     Bookmarked: 14   Downloaded: 150
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: 137,354     Bookmarked: 49   Downloaded: 2,411
Please Sign up or sign in to vote.
Conversion between DataTable and List in C#
18 Jun 2019   Updated: 18 Jun 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 15,853     Bookmarked: 9   Downloaded: 141
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: 13,242     Bookmarked: 5   Downloaded: 206
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: 21,567     Bookmarked: 9   Downloaded: 1,255
Please Sign up or sign in to vote.
Making schedule jobs exe using Quartz scheduler
5 Apr 2020   Updated: 5 Apr 2020   Rating: 4.87/5    Votes: 6   Popularity: 3.79
Licence: CPOL    Views: 31,015     Bookmarked: 7   Downloaded: 278
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: 258,148     Bookmarked: 52   Downloaded: 6,822
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: 26,571     Bookmarked: 23   Downloaded: 385
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.49

Containers
Docker
6 Jul 2022   Updated: 6 Jul 2022   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 7,820     Bookmarked: 13   Downloaded: 118
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: 4,320     Bookmarked: 5   Downloaded: 51
Please Sign up or sign in to vote.
How to run FTP, SFTP, SMTP, Cache, LDAP, SSO and other servers in Docker
Database Development
20 May 2019   Updated: 20 May 2019   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 9,923     Bookmarked: 5   Downloaded: 70
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: 7,091     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: 25,865     Bookmarked: 9   Downloaded: 107
Please Sign up or sign in to vote.
A utility class to send parameters for IN() operator in SQL using parameterized queries
19 Feb 2019   Updated: 19 Feb 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 19,916     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: 5,032     Bookmarked: 3   Downloaded: 74
Please Sign up or sign in to vote.
A utility query to find table generations in SQL Server relational database.
10 Jul 2019   Updated: 10 Jul 2019   Rating: 3.68/5    Votes: 7   Popularity: 3.11
Licence: CPOL    Views: 45,028     Bookmarked: 13   Downloaded: 97
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: 17,790     Bookmarked: 7   Downloaded: 94
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
5 Jul 2022   Updated: 5 Jul 2022   Rating: 3.91/5    Votes: 8   Popularity: 3.53
Licence: CPOL    Views: 3,810     Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
Using CASE with variable/SET, SELECT/UPDATE statement, WHERE clause, JOIN & ON clause
Desktop Programming
8 Feb 2019   Updated: 8 Feb 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 11,604     Bookmarked: 1   Downloaded: 166
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: 15,100     Bookmarked: 9   Downloaded: 97
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: 18,812     Bookmarked: 17   Downloaded: 211
Please Sign up or sign in to vote.
Create hash and compare
Productivity Apps and Services
Microsoft Office
6 Apr 2020   Updated: 6 Apr 2020   Rating: 3.19/5    Votes: 5   Popularity: 2.23
Licence: CPOL    Views: 20,001     Bookmarked: 20   Downloaded: 638
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: 7,094     Bookmarked: 0   Downloaded: 84
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: 47,892     Bookmarked: 16   Downloaded: 384
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: 19,384     Bookmarked: 7   Downloaded: 295
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: 45,625     Bookmarked: 21   Downloaded: 230
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: 6,642     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: 11,891     Bookmarked: 6   Downloaded: 66
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: 3,190     Bookmarked: 4   Downloaded: 22
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: 12,771     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: 10,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: 5,930     Bookmarked: 4   Downloaded: 33
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: 74,635     Bookmarked: 12   Downloaded: 287
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: 25,707     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: 3,810     Bookmarked: 2   Downloaded: 23
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: 11,915     Bookmarked: 1   Downloaded: 55
Please Sign up or sign in to vote.
Configure JSON serialization settings
14 Jul 2020   Updated: 14 Jul 2020   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 28,121     Bookmarked: 10   Downloaded: 821
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: 25,384     Bookmarked: 11   Downloaded: 503
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: 9,472     Bookmarked: 5   Downloaded: 290
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: 28,145     Bookmarked: 17   Downloaded: 356
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: 67,561     Bookmarked: 6   Downloaded: 493
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: 5,783     Bookmarked: 1   Downloaded: 122
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: 18,651     Bookmarked: 3   Downloaded: 12
Please Sign up or sign in to vote.
Delete all the records from the table using Entity Framework
18 Jul 2022   Updated: 18 Jul 2022   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 5,420     Bookmarked: 10   Downloaded: 59
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: 7,593     Bookmarked: 7   Downloaded: 41
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: 7   Popularity: 4.23
Licence: CPOL    Views: 17,573     Bookmarked: 11   Downloaded: 114
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: 175,695     Bookmarked: 30   Downloaded: 2,850
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: 24,393     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: 27,566     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: 51,725     Bookmarked: 8   Downloaded: 1,214
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: 21,580     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,041     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,103     Bookmarked: 6   Downloaded: 111
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: 9,920     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: 24,477     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: 13,630     Bookmarked: 8   Downloaded: 76
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: 31,254     Bookmarked: 8   Downloaded: 315
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: 91,061     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.