tag:blogger.com,1999:blog-75666250314103281452024-02-27T12:36:17.517+05:30Naraayanan's Dot Net ExperienceUpload My Experience and LearningSAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comBlogger338125tag:blogger.com,1999:blog-7566625031410328145.post-55180710251104643162024-02-03T11:02:00.001+05:302024-02-03T11:02:10.322+05:30Boost Your Programming Skills: C# Program for Prime Number Verification<div> Boost Your Programming Skills: C# Program for Prime Number Verification<br /><span style="font-family: courier;">using System;<br />namespace PrimeNumberChecker<br />{<br /> class Program<br /> {<br /> static void Main(string[] args)<br /> {<br /> Console.Write("Enter a number: ");<br /> int number = int.Parse(Console.ReadLine());<br /> if (IsPrime(number))<br /> {<br /> Console.WriteLine($"{number} is a prime number.");<br /> }<br /> else<br /> {<br /> Console.WriteLine($"{number} is not a prime number.");<br /> }<br /> }<br /> public static bool IsPrime(int number)<br /> {<br /> if (number <= 1)<br /> return false; // Not prime if less than or equal to 1<br /> if (number == 2)<br /> return true; // 2 is prime<br /> // Start checking from 2<br /> for (int i = 2; i * i <= number; i++)<br /> {<br /> if (number % i == 0)<br /> return false; // Not prime if divisible by any i<br /> }<br /> return true; // Return true if it is prime<br /> }<br /> }<br />}</span><br />This program defines a function `IsPrime` that checks whether the input number is prime. It handles special cases (less than or equal to 1 and 2) and then iterates from 2 up to the square root of the number to determine primality. If the number is divisible by any integer in this range, it is not prime; otherwise, it is considered prime¹⁴. Feel free to try it out! .</div><p style="text-align: left;"><br /></p>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-79789604259117456032014-08-10T13:07:00.000+05:302014-08-10T13:07:00.820+05:30Could not find any resources appropriate for the specified culture or the neutral culture<div dir="ltr" style="text-align: left;" trbidi="on">
In properties go to Application Tab. Here in applicatin tab verify your assembly name and Default namespace.<br />
You need to change them appropriately in order to eliminate this error.</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-53421331611635359832014-08-09T13:04:00.001+05:302024-01-17T07:36:30.566+05:30A Step-by-Step Guide: Adding Character in the Ascii Sequence to Your String Like a Pro<div dir="ltr" style="text-align: left;" trbidi="on">
Today, we will take a One Scenario for <span face="Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif" style="background-color: white; color: #141823; font-size: 14px; line-height: 19.32px;"> </span><span style="color: #141823;"><span style="font-size: 14px;"><b>A Step-by-Step Guide: Adding Character in the Ascii Sequence to Your String Like a Pro</b></span></span><br />
<span face="Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif" style="background-color: white; color: #141823; font-size: 14px; line-height: 19.32px;">Eg:</span><br />
<span face="Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif" style="background-color: white; color: #141823; font-size: 14px; line-height: 19.32px;"> Input :LAKSHMI</span><br />
<span face="Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif" style="background-color: white; color: #141823; font-size: 14px; line-height: 19.32px;"> Output:LM AB KL ST HI MN IJ.</span><br />
<span face="Helvetica, Arial, 'lucida grande', tahoma, verdana, arial, sans-serif" style="background-color: white; color: #141823; font-size: 14px; line-height: 19.32px;"><b>Here is a Code:</b></span><br />
<div class="code">
#region Declaration<br />
private string _addValue = string.Empty;<br />
private string _result = string.Empty;<br />
private string _res = string.Empty;<br />
#endregion<br />
#region Functions<br />
private string AddValues(string c)<br />
{<br />
switch (c)<br />
{<br />
case "A":
_addValue = "AB";<br />
break;<br />
case "B":
_addValue = "BC";<br />
break;<br />
case "C":<br />
_addValue = "CD";<br />
break;<br />
case "D":<br />
_addValue = "DE";<br />
break;<br />
case "E":<br />
_addValue = "EF";<br />
break;<br />
case "F":<br />
_addValue = "FG";<br />
break;<br />
case "G":<br />
_addValue = "GH";<br />
break;<br />
case "H":<br />
_addValue = "HI";<br />
break;<br />
case "I":<br />
_addValue = "IJ";<br />
break;<br />
case "J":<br />
_addValue = "JK";<br />
break;<br />
case "K":<br />
_addValue = "KL";<br />
break;<br />
case "L":<br />
_addValue = "LM";<br />
break;<br />
case "M":<br />
_addValue = "MN";<br />
break;<br />
case "N":<br />
_addValue = "NO";<br />
break;<br />
case "O":<br />
_addValue = "OP";<br />
break;<br />
case "P":<br />
_addValue = "QR";<br />
break;<br />
case "R":<br />
_addValue = "RS";<br />
break;<br />
case "S":<br />
_addValue = "ST";<br />
break;<br />
case "T":<br />
_addValue = "TU";<br />
break;<br />
case "U":<br />
_addValue = "UV";<br />
break;<br />
case "V":<br />
_addValue = "VW";<br />
break;<br />
case "W":<br />
_addValue = "WX";<br />
break;<br />
case "X":<br />
_addValue = "XY";<br />
break;<br />
case "Y":<br />
_addValue = "YZ";<br />
break;<br />
case "Z":<br />
_addValue = "ZA";<br />
break;<br />
}<br />
return _addValue;<br />
}<br />
private string FinalResult(TextBox txt)<br />
{<br />
String str = Convert.ToString(txt.Text);<br />
char[] szArr = str.ToCharArray();<br />
for (int idx = 0; idx < szArr.Length; idx++)<br />
{<br />
_result = AddValues(Convert.ToString(szArr[idx]));<br />
if (_res == string.Empty)<br />
{<br />
_res = _result;<br />
}<br />
else<br />
{<br />
_res = _res + " " + _result;<br />
}<br />
}<br />
return _res;<br />
}<br />
#endregion
</div>
<b>Call this function in Button Click Event</b><br />
<div class="code">
private void button1_Click(object sender, EventArgs e)<br />
{<br />
textBox2.Text = FinalResult(textBox1);<br />
}<br />
<b>Conclusion:</b><br />
Thanks for your read this article.</div>
</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-34622571364672283972014-08-06T13:03:00.000+05:302014-08-06T13:03:00.642+05:30Find All Monday in Current and Previous Year<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Find All Monday in Current and Previous Year</b><br />
<div class="code">
SELECT Mondays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)
FROM (SELECT TOP 732 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-366 FROM dbo.syscolumns a, dbo.syscolumns b) n
WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Monday'
</div>
</div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-54319239554078390152014-08-06T13:01:00.000+05:302014-08-06T13:01:00.580+05:30Find All Monday in Current Year<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Find All Monday in Current Year</b>
<div class="code">
SELECT Mondays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)
FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n
WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Monday'
</div>
</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-9653128964355140702014-08-05T13:01:00.000+05:302014-08-05T13:01:00.084+05:30Find All Fridays in Current AND Next Year<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Find All Fridays in Current AND Next Year</b><br />
<b><br /></b>
<div class="code">
SELECT Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)
FROM (SELECT TOP 732 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n
WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday'
</div>
<b><br /></b></div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-27912851447994864292014-08-04T13:00:00.000+05:302014-08-04T13:00:02.119+05:30Find All Fridays in Current Year<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Find All Fridays in Current Year
</b><br />
<b><br /></b>
<br />
<div class="code">
SELECT Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)
FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n
WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday'
</div>
<b>
</b></div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-7006810431309930642014-08-03T10:28:00.000+05:302014-08-03T10:28:00.042+05:30Get Only Time from datetime 2008<div dir="ltr" style="text-align: left;" trbidi="on">
<b>get Only Time from datetime 2008</b><br />
<div class="code">
CONVERT(time,GETDATE(),108) AS HourMinuteSecond</div></div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-41412674490328134512014-08-02T10:28:00.000+05:302014-08-02T10:28:00.173+05:30Get Only Date from datetime in SQL Server 2008<div dir="ltr" style="text-align: left;" trbidi="on">
<b>get Only Date from datetime in SQL Server 2008</b><br />
<div class="code">CONVERT(Date,GETDATE(),101) AS DateOnly</div></div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-63684567254526575812014-08-01T12:53:00.004+05:302014-08-01T12:53:39.104+05:30Why OnAfterInstall not trigger<div dir="ltr" style="text-align: left;" trbidi="on">
Please check "<b>Primary Output from </b><app name=""><b> (Active)"</b> in Your Application "<b>Custom Action</b>" Install Folder.
</app></div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-84790701370276928822014-08-01T10:20:00.000+05:302014-08-01T10:20:00.670+05:30Get Only Time from datetime 2005<div dir="ltr" style="text-align: left;" trbidi="on">
<b>get Only Time from datetime 2005</b><br />
<div class="code">
CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond</div>
</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-81744338299511797972014-07-30T14:14:00.000+05:302014-07-30T14:14:00.054+05:3014 Principles on Total Quality Management<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management</b><br />
<b>Dr. Demings’s 14 principles</b><br />
<br />
<ol style="text-align: left;">
<li>Create a constant purpose toward improvement</li>
<li>Adopt the new philosophy</li>
<li>Cease dependence on mass inspection</li>
<li>Use a single supplier for any one item</li>
<li>Improve every process</li>
<li>Create training on the job</li>
<li>Adopt and institute leadership aimed at helping people do a better job</li>
<li>Drive out fear</li>
<li>Break down barriers between departments</li>
<li>Get rid of unclear slogans</li>
<li>Eliminate arbitrary numerical targets</li>
<li>Permit pride of workmanship</li>
<li>Implement education and self-improvement</li>
<li>Make transformation everyone’s job</li>
</ol>
<br />
<br /></div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com1tag:blogger.com,1999:blog-7566625031410328145.post-82550803534195084862014-07-29T14:14:00.000+05:302014-07-29T14:14:00.048+05:30IIF funciton in SQL Server 2012 and give an Example<div dir="ltr" style="text-align: left;" trbidi="on">
If you are using SQL Server 2012 you can use<b> IIF and get the same effect as CASE statement</b>.<br />
<b>Create a Table</b><br />
<div class="code">
CREATE TABLE SimpleTable (ID INT, NAME VARCHAR(10))<br />
GO<br />
Insert some value into table<br />
INSERT INTO SimpleTable (ID, NAME)<br />
SELECT 1, 'LAKSHMI'<br />
UNION ALL<br />
SELECT 2, 'NARAYANAN'<br />
UNION ALL<br />
SELECT 3, 'NARAYANAN'<br />
GO<br /></div>
<b>IIF Statement</b><br />
<div class="code">
UPDATE SimpleTable<br />
SET Gender = IIF(NAME = 'NARAYANAN', 'LAKSHMI', 'NARAYANAN')<br />
GO<br />
SELECT *<br />
FROM SimpleTable<br />
GO<br /></div></div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-31320919933414268142014-07-28T14:12:00.000+05:302014-07-28T14:12:00.601+05:30Example for CASE Function in SQL<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Create a Table</b><br />
<div class="code">
CREATE TABLE SimpleTable (ID INT, NAME VARCHAR(MAX))<br />
GO<br />
Insert some value into table<br />
INSERT INTO SimpleTable (ID, NAME)<br />
SELECT 1, 'LAKSHMI'<br />
UNION ALL<br />
SELECT 2, 'NARAYANAN'<br />
UNION ALL<br />
SELECT 3, 'NARAYANAN'<br />
GO<br /></div>
<b>CASE Funciton:</b><br />
<div class="code">
UPDATE SimpleTable<br />
SET Gender = CASE NAME WHEN 'NARAYANAN' THEN 'LAKSHMI' ELSE 'NARAYANAN' END<br />
GO<br />
SELECT *<br />
FROM SimpleTable<br />
GO<br />
<div>
<br /></div></div>
</div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-80678435636765319692014-07-27T14:11:00.000+05:302014-07-27T14:11:00.480+05:30Example for REPLACE Function in SQL<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Create a Table</b><br />
<div class="code">
CREATE TABLE SimpleTable (ID INT, Gender VARCHAR(10))<br />
GO<br />
Insert some value into table<br />
INSERT INTO SimpleTable (ID, Gender)<br />
SELECT 1, 'female'<br />
UNION ALL<br />
SELECT 2, 'male'<br />
UNION ALL<br />
SELECT 3, 'male'<br />
GO</div>
<b>Replace male into female using UPDATE Query</b><br />
<div class="code">
UPDATE SimpleTable<br />
SET Gender = REPLACE(('fe'+Gender),'fefe','')<br />
GO<br />
SELECT *<br />
FROM SimpleTable<br />
GO</div>
</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-18930789214706120082014-07-26T14:10:00.000+05:302014-07-26T14:10:00.024+05:30SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="code">
SELECT name, create_date, modify_date<br />
FROM sys.objects<br />
WHERE type = 'P'<br />
AND name = '<Sp_name>'<br /><div>
<div>
<br /></div>
</div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-29502864886109199922014-07-26T10:20:00.000+05:302014-07-26T10:20:00.565+05:30Get Current Date in SQL Server 2005<div dir="ltr" style="text-align: left;" trbidi="on">
<b>get Only Date from datetime in SQL Server 2005</b><br />
<div class="code">
GETDATE()<br />
CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly<br />
</div>
</div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-50709873329587647322014-07-24T12:36:00.000+05:302014-07-24T12:36:00.446+05:30Column Exists or Not in SQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="code">
<b>Column Exists or Not in SQL Server</b><br />
<br />
CREATE FUNCTION Axfn_ColumnExists<br />
(<br />
@TableName VARCHAR(100)
,<br />
@ColumnName VARCHAR(100)
)<br />
RETURNS VARCHAR(100)<br />
AS<br />
BEGIN<br />
DECLARE @Result VARCHAR(100);<br />
IF EXISTS<br />
(<br />
SELECT 1
FROM INFORMATION_SCHEMA.Columns<br />
WHERE TABLE_NAME = @TableName
AND COLUMN_NAME = @ColumnName
)
BEGIN<br />
SET @Result = 'Already Exsits'<br />
END<br />
ELSE<br />
BEGIN
SET @Result = 'Not Available, You can create now!'<br />
END
RETURN (@Result)<br />
END<br />
GO</div>
</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-43959804269673273162014-07-23T14:09:00.000+05:302014-07-23T14:09:00.285+05:30SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="code">
SELECT Name<br />
FROM sys.procedures<br />
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%<search_word>%'</div>
<br /></div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-51562220566342807272014-07-22T13:56:00.000+05:302014-07-22T13:56:00.193+05:30CTE in SQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
the common table expression (CTE) is a temporary named result set that you can reference within a <b>SELECT, INSERT, UPDATE, or DELETE</b> statement. You can also use a CTE in a CREATE VIEW statement, as part of the view’s SELECT query. In addition, as of SQL Server 2008, you can add a CTE to the new <b>MERGE </b>statement.</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-82362342879959788162014-07-21T14:07:00.000+05:302014-07-21T14:07:00.564+05:30SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="code">
SELECT DISTINCT o.name, o.xtype<br />
FROM syscomments c<br />
INNER JOIN sysobjects o ON c.id=o.id<br />
WHERE c.TEXT LIKE '%tablename%'<br />
<div>
<div>
<br /></div>
</div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-91700372706807405352014-07-20T14:06:00.000+05:302014-07-20T14:06:00.093+05:30SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="code">
SELECT obj.Name SPName, sc.TEXT SPText<br />
FROM sys.syscomments sc<br />
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID<br />
WHERE sc.TEXT LIKE '%' + 'Name Your Column Here' + '%'<br />
AND TYPE = 'P'<br />
</div>
<br /></div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-50961574460236166762014-07-19T14:05:00.000+05:302014-07-19T14:05:00.145+05:30SQL Constraints<div dir="ltr" style="text-align: left;" trbidi="on">
SQL constraints are used to specify rules for the data in a table.<br />
If there is any violation between the constraint and the data action, the action is aborted by the constraint.<br />
<br />
<b>Syntax for SQL Constraints</b><br />
<b>SQL CREATE TABLE + CONSTRAINT Syntax</b><br />
<br />
<div class="code">
CREATE TABLE table_name<br />
(<br />
column_name1 data_type(size) constraint_name,<br />
column_name2 data_type(size) constraint_name,<br />
column_name3 data_type(size) constraint_name,<br />
....<br />
);<br />
</div>
In SQL, we have the following constraints:<br />
<div class="code">
NOT NULL - Indicates that a column cannot store NULL value<br />
UNIQUE - Ensures that each row for a column must have a unique value<br />
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Ensures that a column (or combination of two or more columns) have an unique identity which helps to find a particular record in a table more easily and quickly<br />
FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table<br />
CHECK - Ensures that the value in a column meets a specific condition<br />
DEFAULT - Specifies a default value when specified none for this column<br />
</div>
<br /></div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0tag:blogger.com,1999:blog-7566625031410328145.post-9952968850145668442014-07-19T09:30:00.000+05:302014-07-19T09:30:02.457+05:30Entity Framework Tips<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Namespace of Entity framework:</b><br />
<b>Entity Framework 5.0:</b><br />
System.Data.Entity<br />
System.Data.Entity.Infrastructure<br />
System.Data.Entity.Migrations<br />
System.Data.Entity.Migrations.Builders<br />
System.Data.Entity.Migrations.Design<br />
System.Data.Entity.Migrations.History<br />
System.Data.Entity.Migrations.Infrastructure<br />
System.Data.Entity.Migrations.Model<br />
System.Data.Entity.Migrations.Sql<br />
System.Data.Entity.Migrations.Utilities<br />
System.Data.Entity.ModelConfiguration<br />
System.Data.Entity.ModelConfiguration.Configuration<br />
System.Data.Entity.ModelConfiguration.Conventions<br />
System.Data.Entity.Validation<br />
******************************************************<br />
<b>Entity Framework 6.0:</b><br />
Microsoft.Data.Entity.Design<br />
Microsoft.Data.Entity.Design.CodeGeneration<br />
Microsoft.Data.Entity.Design.DatabaseGeneration<br />
Microsoft.Data.Entity.Design.DatabaseGeneration.Activities<br />
Microsoft.Data.Entity.Design.DatabaseGeneration.OutputGenerators<br />
Microsoft.Data.Entity.Design.Extensibility<br />
Microsoft.Data.Entity.Design.Templates<br />
Microsoft.Data.Entity.Design.UI.Views.Explorer<br />
Microsoft.Data.Entity.Design.VisualStudio.ModelWizard<br />
Microsoft.Data.Entity.Design.VisualStudio.SingleFileGenerator<br />
Microsoft.Data.Entity.Design.VisualStudio.TextTemplating<br />
System.ComponentModel.DataAnnotations.Schema<br />
System.Data.Entity<br />
System.Data.Entity.Core<br />
System.Data.Entity.Core.Common<br />
System.Data.Entity.Core.Common.CommandTrees<br />
System.Data.Entity.Core.Common.CommandTrees.ExpressionBuilder<br />
System.Data.Entity.Core.Common.CommandTrees.ExpressionBuilder.Spatial<br />
System.Data.Entity.Core.Common.EntitySql<br />
System.Data.Entity.Core.EntityClient<br />
System.Data.Entity.Core.Mapping<br />
System.Data.Entity.Core.Metadata.Edm<br />
System.Data.Entity.Core.Objects<br />
System.Data.Entity.Core.Objects.DataClasses<br />
System.Data.Entity.Infrastructure<br />
System.Data.Entity.Infrastructure.Annotations<br />
System.Data.Entity.Infrastructure.DependencyResolution<br />
System.Data.Entity.Infrastructure.MappingViews<br />
System.Data.Entity.Infrastructure.Pluralization<br />
System.Data.Entity.Migrations<br />
System.Data.Entity.Migrations.Builders<br />
System.Data.Entity.Migrations.Design<br />
System.Data.Entity.Migrations.History<br />
System.Data.Entity.Migrations.Infrastructure<br />
System.Data.Entity.Migrations.Model<br />
System.Data.Entity.Migrations.Sql<br />
System.Data.Entity.Migrations.Utilities<br />
System.Data.Entity.ModelConfiguration<br />
System.Data.Entity.ModelConfiguration.Configuration<br />
System.Data.Entity.ModelConfiguration.Conventions<br />
System.Data.Entity.Spatial<br />
System.Data.Entity.SqlServer<br />
System.Data.Entity.SqlServerCompact<br />
System.Data.Entity.Validation<br />
XamlGeneratedNamespace<br />
******************************************************<br />
<b>Entity Framework 5.0 Features:</b><br />
<br />
<ul style="text-align: left;">
<li>This release can be used in Visual Studio 2010 and Visual Studio 2012 to write applications that target .NET 4.0 and .NET 4.5. When targeting .NET 4.5 this release introduces some new features including enum support, table-valued functions, spatial data types and various performance improvements.</li>
<li>If you create a new model using the Entity Framework Designer in Visual Studio 2012, the EF5 NuGet package will be installed to your project and the generated code will make use of EF5. New ASP.NET projects created in Visual Studio 2012 (including MVC projects) also have the EF5 NuGet package installed by default.</li>
<li>The Entity Framework Designer in Visual Studio 2012 also introduces support for multiple-diagrams per model, coloring of shapes on the design surface and batch import of stored procedures.</li>
</ul>
<br />
*****************************************************************<br />
<b>Entity Framework 6.0 Features:</b><br />
<br />
<ul style="text-align: left;">
<li>Async Query and Save adds support for the task-based asynchronous patterns that were introduced in .NET 4.5.</li>
<li>Connection Resiliency enables automatic recovery from transient connection failures.</li>
<li>Code-Based Configuration gives you the option of performing configuration – that was traditionally performed in a config file – in code.</li>
<li>Dependency Resolution introduces support for the Service Locator pattern and we've factored out some pieces of functionality that can be replaced with custom implementations.</li>
<li>Interception/SQL logging provides low-level building blocks for interception of EF operations with simple SQL logging built on top.</li>
<li>Testability improvements make it easier to create test doubles for DbContext and DbSet when using a mocking framework or writing your own test doubles.</li>
<li>DbContext can now be created with a DbConnection that is already opened which enables scenarios where it would be helpful if the connection could be open when creating the context (such as sharing a connection between components where you can not guarantee the state of the connection).</li>
<li>Improved Transaction Support provides support for a transaction external to the framework as well as improved ways of creating a transaction within the Framework.</li>
<li>Enums, Spatial and Better Performance on .NET 4.0 - By moving the core components that used to be in the .NET Framework into the EF NuGet package we are now able to offer enum support, spatial data types and the performance improvements from EF5 on .NET 4.0.</li>
<li>Improved performance of Enumerable.Contains in LINQ queries.</li>
<li>Improved warm up time (view generation), especially for large models. </li>
<li>Pluggable Pluralization & Singularization Service.</li>
<li>Custom implementations of Equals or GetHashCode on entity classes are now supported.</li>
<li>DbSet.AddRange/RemoveRange provides an optimized way to add or remove multiple entities from a set.</li>
<li>DbChangeTracker.HasChanges provides an easy and efficient way to see if there are any pending changes to be saved to the database.</li>
<li>SqlCeFunctions provides a SQL Compact equivalent to the SqlFunctions.</li>
</ul>
<br />
*****************************************************************</div>
SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.comtag:blogger.com,1999:blog-7566625031410328145.post-80734426427660122602014-07-17T14:01:00.000+05:302014-07-17T14:01:00.315+05:30SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="code">
-- Disable all the constraint in database<br />
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"<br />
</div>
<br />
<div class="code">
-- Enable all the constraint in database<br />
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"<br />
</div>
<div class="urlcode">
<a href="http://blog.sqlauthority.com/2013/04/29/sql-server-disable-all-the-foreign-key-constraint-in-database-enable-all-the-foreign-key-constraint-in-database/">Refer this link</a>
<br />
<div>
<div>
<br /></div>
</div>SAP B1 Narayananhttp://www.blogger.com/profile/08437133854593924619noreply@blogger.com0